PSP Archive History
Description
- Categories
- BI Publisher
- Application
- Labor Distribution
- Source
- PSP: Archive History Report (XML)
- Short Name
- PSPARREP_XML
- DB package
- PSP_PSPARREP_XMLP_PKG
Imported from BI Publisher
Archive History Report
Archive History Report
SQL 33 lines
SELECT DISTINCT PPF.payroll_name payroll_name, PTP.start_date start_date, PTP.end_date end_date, PTP.period_name, 'A' func_area FROM PSP_PAYROLL_CONTROLS PPC, PER_TIME_PERIODS PTP, PAY_PAYROLLS_F PPF WHERE PPC.payroll_id = PPF.payroll_id and PPC.time_period_id = PTP.time_period_id and PPC.payroll_id = nvl(:p_payroll_id,PPF.payroll_id) and PTP.time_period_id >= nvl(:p_begin_period,PTP.time_period_id) and PTP.time_period_id <= nvl(:p_end_period,PTP.time_period_id) and PPC.archive_flag = 'Y' UNION SELECT DISTINCT PPF.payroll_name payroll_name, PTP.start_date start_date, PTP.end_date end_date, PTP.period_name, 'E' func_area FROM PSP_ENC_CONTROLS PEC, PER_TIME_PERIODS PTP, PAY_PAYROLLS_F PPF WHERE PEC.payroll_id = PPF.payroll_id and PEC.time_period_id = PTP.time_period_id and PEC.payroll_id = nvl(:p_payroll_id,PPF.payroll_id) and PTP.time_period_id >= nvl(:p_begin_period,PTP.time_period_id) and PTP.time_period_id <= nvl(:p_end_period,PTP.time_period_id) and PEC.archive_flag = 'Y' ORDER BY 1,2,5 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Payroll Name | LOV Oracle | |
| Begin Time Period | LOV Oracle | |
| End Time Period | LOV Oracle |