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_ADJUSTMENT_LINES_HISTORY

Line 359: -- Insert data into archive table PSP_ADJUSTMENT_LINES_ARCH from PSP_ADJUSTMENT_LINES_HISTORY for the valid_period

355: PSP_SUMMARY_LINES PSL
356: WHERE PDLH.summary_line_id = PSL.summary_line_id
357: and PSL.time_period_id = valid_period_rec.time_period_id ;
358:
359: -- Insert data into archive table PSP_ADJUSTMENT_LINES_ARCH from PSP_ADJUSTMENT_LINES_HISTORY for the valid_period
360: INSERT INTO PSP_ADJUSTMENT_LINES_ARCH
361: (
362: adjustment_line_id, person_id,
363: assignment_id, element_type_id,

Line 421: FROM PSP_ADJUSTMENT_LINES_HISTORY PALH

417: PALH.last_updated_by, PALH.last_update_login,
418: PALH.created_by, PALH.creation_date,
419: PALH.source_type, PALH.business_group_id,
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

Line 563: -- Delete from the actual table PSP_ADJUSTMENT_LINES_HISTORY for the valid_period

559: WHERE PSL.summary_line_id = PDLH.summary_line_id
560: and PSL.time_period_id = valid_period_rec.time_period_id
561: );
562:
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

Line 564: DELETE PSP_ADJUSTMENT_LINES_HISTORY PALH

560: and PSL.time_period_id = valid_period_rec.time_period_id
561: );
562:
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

Line 777: -- Insert data from archive table PSP_ADJUSTMENT_LINES_ARCH into PSP_ADJUSTMENT_LINES_HISTORY for the valid_period

773: PSP_SUMMARY_LINES_ARCH PSLA
774: WHERE PDLA.summary_line_id = PSLA.summary_line_id
775: and PSLA.time_period_id = valid_period_rec.time_period_id ;
776:
777: -- Insert data from archive table PSP_ADJUSTMENT_LINES_ARCH into PSP_ADJUSTMENT_LINES_HISTORY for the valid_period
778: INSERT INTO PSP_ADJUSTMENT_LINES_HISTORY
779: (
780: adjustment_line_id, person_id,
781: assignment_id, element_type_id,

Line 778: INSERT INTO PSP_ADJUSTMENT_LINES_HISTORY

774: WHERE PDLA.summary_line_id = PSLA.summary_line_id
775: and PSLA.time_period_id = valid_period_rec.time_period_id ;
776:
777: -- Insert data from archive table PSP_ADJUSTMENT_LINES_ARCH into PSP_ADJUSTMENT_LINES_HISTORY for the valid_period
778: INSERT INTO PSP_ADJUSTMENT_LINES_HISTORY
779: (
780: adjustment_line_id, person_id,
781: assignment_id, element_type_id,
782: distribution_date, effective_date,