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_ENC_SUMMARY_LINES_ARCH

Line 1206: -- Insert data Into PSP_ENC_SUMMARY_LINES_ARCH from PSP_ENC_SUMMARY_LINES for the current period

1202: pelh.hierarchy_start_date, pelh.hierarchy_end_date
1203: FROM PSP_ENC_LINES_HISTORY PELH
1204: WHERE PELH.time_period_id = l_time_period;
1205:
1206: -- Insert data Into PSP_ENC_SUMMARY_LINES_ARCH from PSP_ENC_SUMMARY_LINES for the current period
1207: INSERT INTO PSP_ENC_SUMMARY_LINES_ARCH
1208: (enc_summary_line_id, business_group_id, gms_batch_name,
1209: time_period_id, person_id, assignment_id,
1210: effective_date, set_of_books_id, gl_code_combination_id,

Line 1207: INSERT INTO PSP_ENC_SUMMARY_LINES_ARCH

1203: FROM PSP_ENC_LINES_HISTORY PELH
1204: WHERE PELH.time_period_id = l_time_period;
1205:
1206: -- Insert data Into PSP_ENC_SUMMARY_LINES_ARCH from PSP_ENC_SUMMARY_LINES for the current period
1207: INSERT INTO PSP_ENC_SUMMARY_LINES_ARCH
1208: (enc_summary_line_id, business_group_id, gms_batch_name,
1209: time_period_id, person_id, assignment_id,
1210: effective_date, set_of_books_id, gl_code_combination_id,
1211: project_id, expenditure_organization_id, expenditure_type,

Line 1455: -- Insert data Into PSP_ENC_SUMMARY_LINES from PSP_ENC_SUMMARY_LINES_ARCH for the current period

1451: pela.hierarchy_start_date, pela.hierarchy_end_date
1452: FROM PSP_ENC_LINES_ARCH PELA
1453: WHERE PELA.time_period_id = l_time_period;
1454:
1455: -- Insert data Into PSP_ENC_SUMMARY_LINES from PSP_ENC_SUMMARY_LINES_ARCH for the current period
1456: INSERT INTO PSP_ENC_SUMMARY_LINES
1457: (enc_summary_line_id, business_group_id, gms_batch_name,
1458: time_period_id, person_id, assignment_id,
1459: effective_date, set_of_books_id, gl_code_combination_id,

Line 1509: FROM PSP_ENC_SUMMARY_LINES_ARCH PESLA

1505: PESLA.expenditure_id, PESLA.expenditure_item_id, --added five exp columns for 2445196
1506: PESLA.expenditure_ending_date, PESLA.interface_id,
1507: PESLA.txn_interface_id, payroll_action_id, liquidate_request_id, proposed_termination_date, update_flag
1508:
1509: FROM PSP_ENC_SUMMARY_LINES_ARCH PESLA
1510: WHERE PESLA.time_period_id = l_time_period;
1511:
1512: -- Purge the archived data
1513: -- Delete from PSP_ENC_LINES_ARCH for the current period

Line 1517: -- Delete from PSP_ENC_SUMMARY_LINES_ARCH for the current period

1513: -- Delete from PSP_ENC_LINES_ARCH for the current period
1514: DELETE PSP_ENC_LINES_ARCH
1515: WHERE time_period_id = l_time_period;
1516:
1517: -- Delete from PSP_ENC_SUMMARY_LINES_ARCH for the current period
1518: DELETE PSP_ENC_SUMMARY_LINES_ARCH
1519: WHERE time_period_id = l_time_period;
1520:
1521: -- Update the status of archive_flag in PSP_ENC_CONTROLS to NULL

Line 1518: DELETE PSP_ENC_SUMMARY_LINES_ARCH

1514: DELETE PSP_ENC_LINES_ARCH
1515: WHERE time_period_id = l_time_period;
1516:
1517: -- Delete from PSP_ENC_SUMMARY_LINES_ARCH for the current period
1518: DELETE PSP_ENC_SUMMARY_LINES_ARCH
1519: WHERE time_period_id = l_time_period;
1520:
1521: -- Update the status of archive_flag in PSP_ENC_CONTROLS to NULL
1522: Update PSP_ENC_CONTROLS