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

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 1258: FROM PSP_ENC_SUMMARY_LINES PESL

1254: PESL.gl_posting_override_date,
1255: PESL.expenditure_id, PESL.expenditure_item_id, -- added five exp columns for 2445196
1256: PESL.expenditure_ending_date, PESL.interface_id,
1257: PESL.txn_interface_id, payroll_action_id, liquidate_request_id, proposed_termination_date, update_flag
1258: FROM PSP_ENC_SUMMARY_LINES PESL
1259: WHERE PESL.time_period_id = l_time_period;
1260:
1261: -- Purge the archived data
1262: -- Delete from PSP_ENC_LINES_HISTORY for the current period

Line 1266: -- Delete from PSP_ENC_SUMMARY_LINES for the current period

1262: -- Delete from PSP_ENC_LINES_HISTORY for the current period
1263: DELETE PSP_ENC_LINES_HISTORY
1264: WHERE time_period_id = l_time_period;
1265:
1266: -- Delete from PSP_ENC_SUMMARY_LINES for the current period
1267: DELETE PSP_ENC_SUMMARY_LINES
1268: WHERE time_period_id = l_time_period;
1269:
1270: -- Update the status of archive_flag in PSP_ENC_CONTROLS to 'Y'

Line 1267: DELETE PSP_ENC_SUMMARY_LINES

1263: DELETE PSP_ENC_LINES_HISTORY
1264: WHERE time_period_id = l_time_period;
1265:
1266: -- Delete from PSP_ENC_SUMMARY_LINES for the current period
1267: DELETE PSP_ENC_SUMMARY_LINES
1268: WHERE time_period_id = l_time_period;
1269:
1270: -- Update the status of archive_flag in PSP_ENC_CONTROLS to 'Y'
1271: Update PSP_ENC_CONTROLS

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 1456: INSERT INTO PSP_ENC_SUMMARY_LINES

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,
1460: project_id, expenditure_organization_id, expenditure_type,

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