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_SUMMARY_LINES

Line 355: PSP_SUMMARY_LINES PSL

351: pdlh.funding_source_code, pdlh.annual_salary_cap,
352: pdlh.cap_excess_dist_line_id, pdlh.suspense_auto_glccid,
353: pdlh.suspense_auto_exp_type, pdlh.adj_account_flag -- added for 5080403
354: FROM PSP_DISTRIBUTION_LINES_HISTORY PDLH,
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

Line 477: -- Insert data into archive table PSP_SUMMARY_LINES_ARCH from PSP_SUMMARY_LINES for the valid_period

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
479: (
480: summary_line_id, source_type,
481: source_code, time_period_id,

Line 478: INSERT INTO PSP_SUMMARY_LINES_ARCH

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
479: (
480: summary_line_id, source_type,
481: source_code, time_period_id,
482: interface_batch_name, person_id,

Line 550: FROM PSP_SUMMARY_LINES PSL

546: PSL.gms_batch_name, PSL.gms_posting_effective_date,/*posting eff dt added for zero work days */
547: PSL.expenditure_id, PSL.expenditure_item_id, -- added five exp columns for 2445196
548: PSL.expenditure_ending_date, PSL.interface_id,
549: PSL.txn_interface_id, PSL.actual_summary_amount --For bug 2496661 : Added a new column actual_summary_amount
550: FROM PSP_SUMMARY_LINES PSL
551: WHERE PSL.time_period_id = valid_period_rec.time_period_id;
552:
553: -- Delete from the actual table PSP_DISTRIBUTION_LINES_HISTORY for the valid_period
554: DELETE PSP_DISTRIBUTION_LINES_HISTORY PDLH

Line 558: FROM PSP_SUMMARY_LINES PSL

554: DELETE PSP_DISTRIBUTION_LINES_HISTORY PDLH
555: WHERE PDLH.summary_line_id in
556: (
557: SELECT PSL.summary_line_id
558: FROM PSP_SUMMARY_LINES PSL
559: WHERE PSL.summary_line_id = PDLH.summary_line_id
560: and PSL.time_period_id = valid_period_rec.time_period_id
561: );
562:

Line 571: -- Delete from the actual table PSP_SUMMARY_LINES for the valid_period

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
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'

Line 572: DELETE PSP_SUMMARY_LINES PSL

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
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

Line 773: PSP_SUMMARY_LINES_ARCH PSLA

769: pdla.funding_source_code, pdla.annual_salary_cap,
770: pdla.cap_excess_dist_line_id, pdla.suspense_auto_glccid,
771: pdla.suspense_auto_exp_type, pdla.adj_account_flag
772: FROM PSP_DISTRIBUTION_LINES_ARCH PDLA,
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

Line 897: -- Insert data from archive table PSP_SUMMARY_LINES_ARCH into PSP_SUMMARY_LINES for the valid_period

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
899: (
900: summary_line_id, source_type,
901: source_code, time_period_id,

Line 898: INSERT INTO PSP_SUMMARY_LINES

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
899: (
900: summary_line_id, source_type,
901: source_code, time_period_id,
902: interface_batch_name, person_id,

Line 970: FROM PSP_SUMMARY_LINES_ARCH PSLA

966: PSLA.gms_batch_name, PSLA.gms_posting_effective_date, /* column been added for zero work days */
967: PSLA.expenditure_id, PSLA.expenditure_item_id, -- added five columns for 2445196
968: PSLA.expenditure_ending_date, PSLA.interface_id,
969: PSLA.txn_interface_id, PSLA.actual_summary_amount --For Bug 2496661: Added new column
970: FROM PSP_SUMMARY_LINES_ARCH PSLA
971: WHERE PSLA.time_period_id = valid_period_rec.time_period_id;
972:
973: -- Delete from the archive table PSP_DISTRIBUTION_LINES_ARCH for the valid_period
974: DELETE PSP_DISTRIBUTION_LINES_ARCH PDLA

Line 978: FROM PSP_SUMMARY_LINES PSLA

974: DELETE PSP_DISTRIBUTION_LINES_ARCH PDLA
975: WHERE PDLA.summary_line_id in
976: (
977: SELECT PSLA.summary_line_id
978: FROM PSP_SUMMARY_LINES PSLA
979: WHERE PSLA.summary_line_id = PDLA.summary_line_id
980: and PSLA.time_period_id = valid_period_rec.time_period_id
981: );
982:

Line 991: -- Delete from the archive table PSP_SUMMARY_LINES_ARCH for the valid_period

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
993: DELETE PSP_SUMMARY_LINES_ARCH PSLA
994: WHERE PSLA.time_period_id = valid_period_rec.time_period_id;
995:

Line 992: -- Replaced PSP_SUMMARY_LINES table with PSP_SUMMARY_LINES_ARCH for bug fix 1761830

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
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

Line 993: DELETE PSP_SUMMARY_LINES_ARCH PSLA

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
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