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_DISTRIBUTION_LINES_ARCH

Line 302: -- Insert data into archive table PSP_DISTRIBUTION_LINES_ARCH from PSP_DISTRIBUTION_LINES_HISTORY for the valid_period

298: FETCH valid_period_cur INTO valid_period_rec;
299: EXIT WHEN valid_period_cur%NOTFOUND ;
300: l_period_name := valid_period_rec.period_name;
301:
302: -- Insert data into archive table PSP_DISTRIBUTION_LINES_ARCH from PSP_DISTRIBUTION_LINES_HISTORY for the valid_period
303: INSERT INTO PSP_DISTRIBUTION_LINES_ARCH
304: (
305: distribution_line_id, distribution_date,
306: effective_date, distribution_amount,

Line 303: INSERT INTO PSP_DISTRIBUTION_LINES_ARCH

299: EXIT WHEN valid_period_cur%NOTFOUND ;
300: l_period_name := valid_period_rec.period_name;
301:
302: -- Insert data into archive table PSP_DISTRIBUTION_LINES_ARCH from PSP_DISTRIBUTION_LINES_HISTORY for the valid_period
303: INSERT INTO PSP_DISTRIBUTION_LINES_ARCH
304: (
305: distribution_line_id, distribution_date,
306: effective_date, distribution_amount,
307: status_code, default_reason_code,

Line 719: -- Insert data from archive table PSP_DISTRIBUTION_LINES_ARCH into PSP_DISTRIBUTION_LINES_HISTORY for the valid_period

715: EXIT WHEN valid_period_cur%NOTFOUND ;
716: l_period_name := valid_period_rec.period_name;
717:
718:
719: -- Insert data from archive table PSP_DISTRIBUTION_LINES_ARCH into PSP_DISTRIBUTION_LINES_HISTORY for the valid_period
720:
721: INSERT INTO PSP_DISTRIBUTION_LINES_HISTORY
722: (
723: distribution_line_id, distribution_date,

Line 772: FROM PSP_DISTRIBUTION_LINES_ARCH PDLA,

768: pdla.cap_excess_exp_type, pdla.cap_excess_exp_org_id,
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:

Line 973: -- Delete from the archive table PSP_DISTRIBUTION_LINES_ARCH for the valid_period

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
975: WHERE PDLA.summary_line_id in
976: (
977: SELECT PSLA.summary_line_id

Line 974: DELETE PSP_DISTRIBUTION_LINES_ARCH PDLA

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
975: WHERE PDLA.summary_line_id in
976: (
977: SELECT PSLA.summary_line_id
978: FROM PSP_SUMMARY_LINES PSLA