APPS.PSP_ARCHIVE_RETRIEVE dependencies on PSP_ENC_CONTROLS

Line 1053: FROM PSP_ENC_CONTROLS PEC,

1049: IS
1050: -- Cursor to select invalid time periods
1051: CURSOR invalid_period_cur
1052: IS Select distinct period_name
1053: FROM PSP_ENC_CONTROLS PEC,
1054: PER_TIME_PERIODS PTP
1055: WHERE PEC.time_period_id = PTP.time_period_id
1056: AND PEC.payroll_id = p_payroll_id
1057: AND PEC.time_period_id >= p_begin_period

Line 1061: FROM PSP_ENC_CONTROLS PEC2

1057: AND PEC.time_period_id >= p_begin_period
1058: AND PEC.time_period_id <= p_end_period
1059: AND PEC.archive_flag is NULL
1060: AND PEC.time_period_id in (SELECT time_period_id
1061: FROM PSP_ENC_CONTROLS PEC2
1062: WHERE PEC2.time_period_id = PEC.time_period_id
1063: AND PEC2.action_code <> 'L');
1064:
1065: -- Cursor to select valid periods that can be archived

Line 1068: FROM PSP_ENC_CONTROLS PEC,

1064:
1065: -- Cursor to select valid periods that can be archived
1066: CURSOR valid_period_cur
1067: IS SELECT distinct PEC.time_period_id, PTP.period_name
1068: FROM PSP_ENC_CONTROLS PEC,
1069: PER_TIME_PERIODS PTP
1070: WHERE PTP.time_period_id = PEC.time_period_id
1071: AND PEC.payroll_id = p_payroll_id
1072: AND PEC.time_period_id >= p_begin_period

Line 1270: -- Update the status of archive_flag in PSP_ENC_CONTROLS to 'Y'

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
1272: Set archive_flag = 'Y'
1273: WHERE time_period_id = l_time_period;
1274:

Line 1271: Update PSP_ENC_CONTROLS

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
1272: Set archive_flag = 'Y'
1273: WHERE time_period_id = l_time_period;
1274:
1275: -- Commit the changes made for thecurrent period

Line 1351: FROM PSP_ENC_CONTROLS PEC,

1347: -- Cursor for selecting valid time periods
1348: -- For bug fix 17770033, 1778727, changed the begin period to end period check as the functionality had changed
1349: CURSOR valid_period_cur
1350: IS SELECT distinct PEC.time_period_id, PTP.period_name
1351: FROM PSP_ENC_CONTROLS PEC,
1352: PER_TIME_PERIODS PTP
1353: WHERE PTP.time_period_id = PEC.time_period_id
1354: AND PEC.payroll_id = p_payroll_id
1355: AND PEC.time_period_id >= p_begin_period

Line 1521: -- Update the status of archive_flag in PSP_ENC_CONTROLS to NULL

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
1523: Set archive_flag = NULL
1524: WHERE time_period_id = l_time_period;
1525:

Line 1522: Update PSP_ENC_CONTROLS

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
1523: Set archive_flag = NULL
1524: WHERE time_period_id = l_time_period;
1525:
1526: -- Commit the changes made for thecurrent period