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_PRE_GEN_DIST_LINES_ARCH

Line 424: -- Insert data into archive table PSP_PRE_GEN_DIST_LINES_ARCH from PSP_PRE_GEN_LINES_HISTORY for the valid_period.

420: PALH.adj_set_number, PALH.line_number
421: FROM PSP_ADJUSTMENT_LINES_HISTORY PALH
422: WHERE PALH.time_period_id = valid_period_rec.time_period_id ;
423:
424: -- Insert data into archive table PSP_PRE_GEN_DIST_LINES_ARCH from PSP_PRE_GEN_LINES_HISTORY for the valid_period.
425: INSERT INTO PSP_PRE_GEN_DIST_LINES_ARCH
426: (
427: pre_gen_dist_line_id, distribution_interface_id,
428: person_id, assignment_id,

Line 425: INSERT INTO PSP_PRE_GEN_DIST_LINES_ARCH

421: FROM PSP_ADJUSTMENT_LINES_HISTORY PALH
422: WHERE PALH.time_period_id = valid_period_rec.time_period_id ;
423:
424: -- Insert data into archive table PSP_PRE_GEN_DIST_LINES_ARCH from PSP_PRE_GEN_LINES_HISTORY for the valid_period.
425: INSERT INTO PSP_PRE_GEN_DIST_LINES_ARCH
426: (
427: pre_gen_dist_line_id, distribution_interface_id,
428: person_id, assignment_id,
429: element_type_id, distribution_date,

Line 843: -- Insert data from archive table PSP_PRE_GEN_DIST_LINES_ARCH into PSP_PRE_GEN_LINES_HISTORY for the valid_period.

839: PALA.adj_set_number, PALA.line_number
840: FROM PSP_ADJUSTMENT_LINES_ARCH PALA
841: WHERE PALA.time_period_id = valid_period_rec.time_period_id ;
842:
843: -- Insert data from archive table PSP_PRE_GEN_DIST_LINES_ARCH into PSP_PRE_GEN_LINES_HISTORY for the valid_period.
844: INSERT INTO PSP_PRE_GEN_DIST_LINES_HISTORY
845: (
846: pre_gen_dist_line_id, distribution_interface_id,
847: person_id, assignment_id,

Line 894: FROM PSP_PRE_GEN_DIST_LINES_ARCH PGDLA

890: pgdla.attribute5, pgdla.attribute6,
891: pgdla.attribute7, pgdla.attribute8,
892: pgdla.attribute9, pgdla.attribute10,
893: pgdla.suspense_auto_glccid, pgdla.suspense_auto_exp_type
894: FROM PSP_PRE_GEN_DIST_LINES_ARCH PGDLA
895: WHERE PGDLA.time_period_id = valid_period_rec.time_period_id ;
896:
897: -- Insert data from archive table PSP_SUMMARY_LINES_ARCH into PSP_SUMMARY_LINES for the valid_period
898: INSERT INTO PSP_SUMMARY_LINES

Line 987: -- Delete from the archive table PSP_PRE_GEN_DIST_LINES_ARCH for the curr_period

983: -- Delete from the archive table PSP_ADJUSTMENT_LINES_ARCH for the valid_period
984: DELETE PSP_ADJUSTMENT_LINES_ARCH PALA
985: WHERE PALA.time_period_id = valid_period_rec.time_period_id;
986:
987: -- Delete from the archive table PSP_PRE_GEN_DIST_LINES_ARCH for the curr_period
988: DELETE PSP_PRE_GEN_DIST_LINES_ARCH PPGDA
989: WHERE PPGDA.time_period_id = valid_period_rec.time_period_id;
990:
991: -- Delete from the archive table PSP_SUMMARY_LINES_ARCH for the valid_period

Line 988: DELETE PSP_PRE_GEN_DIST_LINES_ARCH PPGDA

984: DELETE PSP_ADJUSTMENT_LINES_ARCH PALA
985: WHERE PALA.time_period_id = valid_period_rec.time_period_id;
986:
987: -- Delete from the archive table PSP_PRE_GEN_DIST_LINES_ARCH for the curr_period
988: DELETE PSP_PRE_GEN_DIST_LINES_ARCH PPGDA
989: WHERE PPGDA.time_period_id = valid_period_rec.time_period_id;
990:
991: -- Delete from the archive table PSP_SUMMARY_LINES_ARCH for the valid_period
992: -- Replaced PSP_SUMMARY_LINES table with PSP_SUMMARY_LINES_ARCH for bug fix 1761830