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_HISTORY

Line 474: FROM PSP_PRE_GEN_DIST_LINES_HISTORY PGDLH

470: pgdlh.attribute5, pgdlh.attribute6,
471: pgdlh.attribute7, pgdlh.attribute8,
472: pgdlh.attribute9, pgdlh.attribute10,
473: pgdlh.suspense_auto_glccid, pgdlh.suspense_auto_exp_type
474: FROM PSP_PRE_GEN_DIST_LINES_HISTORY PGDLH
475: WHERE PGDLH.time_period_id = valid_period_rec.time_period_id ;
476:
477: -- Insert data into archive table PSP_SUMMARY_LINES_ARCH from PSP_SUMMARY_LINES for the valid_period
478: INSERT INTO PSP_SUMMARY_LINES_ARCH

Line 567: -- Delete from the actual table PSP_PRE_GEN_DIST_LINES_HISTORYfor the curr_period

563: -- Delete from the actual table PSP_ADJUSTMENT_LINES_HISTORY for the valid_period
564: DELETE PSP_ADJUSTMENT_LINES_HISTORY PALH
565: WHERE PALH.time_period_id = valid_period_rec.time_period_id;
566:
567: -- Delete from the actual table PSP_PRE_GEN_DIST_LINES_HISTORYfor the curr_period
568: DELETE PSP_PRE_GEN_DIST_LINES_HISTORY PPGDH
569: WHERE PPGDH. time_period_id = valid_period_rec.time_period_id;
570:
571: -- Delete from the actual table PSP_SUMMARY_LINES for the valid_period

Line 568: DELETE PSP_PRE_GEN_DIST_LINES_HISTORY PPGDH

564: DELETE PSP_ADJUSTMENT_LINES_HISTORY PALH
565: WHERE PALH.time_period_id = valid_period_rec.time_period_id;
566:
567: -- Delete from the actual table PSP_PRE_GEN_DIST_LINES_HISTORYfor the curr_period
568: DELETE PSP_PRE_GEN_DIST_LINES_HISTORY PPGDH
569: WHERE PPGDH. time_period_id = valid_period_rec.time_period_id;
570:
571: -- Delete from the actual table PSP_SUMMARY_LINES for the valid_period
572: DELETE PSP_SUMMARY_LINES PSL

Line 844: INSERT INTO PSP_PRE_GEN_DIST_LINES_HISTORY

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,
848: element_type_id, distribution_date,