eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ARCHIVE_RETRIEVE dependencies on PSP_PAYROLL_CONTROLS

Line 30: FROM PSP_PAYROLL_CONTROLS PPC,

26: CURSOR error_check_cur IS
27: SELECT distinct PPC.source_type,
28: PPC.time_period_id,
29: PTP.period_name
30: FROM PSP_PAYROLL_CONTROLS PPC,
31: PER_TIME_PERIODS PTP
32: WHERE PPC.time_period_id = PTP.time_period_id
33: and PPC.payroll_id = p_payroll_id
34: and PPC.time_period_id >= p_begin_period

Line 42: -- FROM psp_payroll_controls PPC2

38: and PPC.archive_flag is NULL
39: --For bug fix 1767315
40: and PPC.status_code <> 'P'
41: --and PPC.time_period_id in ( SELECT PPC2.time_period_id
42: -- FROM psp_payroll_controls PPC2
43: -- WHERE PPC2.time_period_id = PPC.time_period_id
44: -- and PPC2.status_code <> 'P'
45: -- )
46: --End of Bug fix

Line 117: FROM PSP_PAYROLL_CONTROLS PPC,

113: -- Included 'distinct' in the select for bug fix 1759548
114: CURSOR valid_period_cur IS
115: SELECT distinct PPC.time_period_id,
116: PTP.period_name
117: FROM PSP_PAYROLL_CONTROLS PPC,
118: PER_TIME_PERIODS PTP
119: WHERE PPC.payroll_id = p_payroll_id
120: and PPC.time_period_id >= p_begin_period
121: and PPC.time_period_id <= p_end_period

Line 575: -- Update the status of archive_flag in PSP_PAYROLL_CONTROLS to 'Y'

571: -- Delete from the actual table PSP_SUMMARY_LINES for the valid_period
572: DELETE PSP_SUMMARY_LINES PSL
573: WHERE PSL.time_period_id = valid_period_rec.time_period_id;
574:
575: -- Update the status of archive_flag in PSP_PAYROLL_CONTROLS to 'Y'
576: UPDATE PSP_PAYROLL_CONTROLS PPC
577: SET PPC.archive_flag = 'Y'
578: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
579:

Line 576: UPDATE PSP_PAYROLL_CONTROLS PPC

572: DELETE PSP_SUMMARY_LINES PSL
573: WHERE PSL.time_period_id = valid_period_rec.time_period_id;
574:
575: -- Update the status of archive_flag in PSP_PAYROLL_CONTROLS to 'Y'
576: UPDATE PSP_PAYROLL_CONTROLS PPC
577: SET PPC.archive_flag = 'Y'
578: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
579:
580: Commit;

Line 643: FROM PSP_PAYROLL_CONTROLS PPC,

639: -- For bug fix 1777003, 1778727, retained the following select stmt. as the functionality had changed.
640: CURSOR valid_period_cur IS
641: SELECT distinct PPC.time_period_id,
642: PTP.period_name
643: FROM PSP_PAYROLL_CONTROLS PPC,
644: PER_TIME_PERIODS PTP
645: WHERE PPC.payroll_id = p_payroll_id
646: and PPC.time_period_id >= p_begin_period
647: and PPC.time_period_id <= p_end_period

Line 996: -- Update the status of archive_flag in PSP_PAYROLL_CONTROLS to NULL

992: -- Replaced PSP_SUMMARY_LINES table with PSP_SUMMARY_LINES_ARCH for bug fix 1761830
993: DELETE PSP_SUMMARY_LINES_ARCH PSLA
994: WHERE PSLA.time_period_id = valid_period_rec.time_period_id;
995:
996: -- Update the status of archive_flag in PSP_PAYROLL_CONTROLS to NULL
997: UPDATE PSP_PAYROLL_CONTROLS PPC
998: SET PPC.archive_flag = NULL
999: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
1000:

Line 997: UPDATE PSP_PAYROLL_CONTROLS PPC

993: DELETE PSP_SUMMARY_LINES_ARCH PSLA
994: WHERE PSLA.time_period_id = valid_period_rec.time_period_id;
995:
996: -- Update the status of archive_flag in PSP_PAYROLL_CONTROLS to NULL
997: UPDATE PSP_PAYROLL_CONTROLS PPC
998: SET PPC.archive_flag = NULL
999: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
1000:
1001: Commit;