APPS.PAY_AU_TERMINATIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 543: from pay_assignment_actions ASGT_ACTION

539: from pay_run_results RESULT
540: where result.source_id = l_source_id --Bug 3306112
541: and result.status <> 'U'
542: and exists ( select 1
543: from pay_assignment_actions ASGT_ACTION
544: , pay_payroll_actions PAY_ACTION
545: , per_time_periods PERIOD
546: where result.assignment_action_id = asgt_action.assignment_action_id
547: and asgt_action.payroll_action_id = pay_action.payroll_action_id

Line 1288: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;

1284:
1285:
1286: -- Variable to store the maximum previous year assignment action id and its corresponding
1287: -- tax_unit_id (legal Employer).
1288: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1290:
1291:
1292: -- Total Earnings variable

Line 1289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1285:
1286: -- Variable to store the maximum previous year assignment action id and its corresponding
1287: -- tax_unit_id (legal Employer).
1288: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1290:
1291:
1292: -- Total Earnings variable
1293: --

Line 1315: FROM pay_assignment_actions paa

1311: c_fin_start_date in date,
1312: c_fin_end_date in date)
1313: IS
1314: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id
1315: FROM pay_assignment_actions paa
1316: ,pay_payroll_actions ppa
1317: WHERE paa.assignment_id = c_assignment_id
1318: and ppa.payroll_action_id = paa.payroll_action_id
1319: and ppa.business_group_id = c_business_group_id

Line 1323: FROM pay_assignment_actions paa,

1319: and ppa.business_group_id = c_business_group_id
1320: AND paa.action_sequence in
1321: (
1322: SELECT MAX(paa.action_sequence)
1323: FROM pay_assignment_actions paa,
1324: pay_payroll_actions ppa,
1325: per_all_assignments_f paaf
1326: WHERE ppa.business_group_id = c_business_group_id
1327: AND paaf.assignment_id = c_assignment_id

Line 1345: FROM pay_assignment_actions paa

1341: c_fin_start_date in date,
1342: c_fin_end_date in date)
1343: IS
1344: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date
1345: FROM pay_assignment_actions paa
1346: ,pay_payroll_actions ppa
1347: WHERE paa.assignment_id = c_assignment_id
1348: and ppa.payroll_action_id = paa.payroll_action_id
1349: and ppa.business_group_id = c_business_group_id

Line 1353: FROM pay_assignment_actions paa,

1349: and ppa.business_group_id = c_business_group_id
1350: AND paa.action_sequence in
1351: (
1352: SELECT MAX(paa.action_sequence)
1353: FROM pay_assignment_actions paa,
1354: pay_payroll_actions ppa,
1355: per_all_assignments_f paaf
1356: WHERE ppa.business_group_id = c_business_group_id
1357: AND paaf.assignment_id = c_assignment_id

Line 1407: pay_assignment_actions paa

1403: CURSOR c_get_payroll_effective_date
1404: IS
1405: SELECT ppa.effective_date
1406: FROM pay_payroll_actions ppa,
1407: pay_assignment_actions paa
1408: WHERE paa.assignment_action_id = p_assignment_action_id
1409: AND ppa.payroll_action_id = paa.payroll_action_id;
1410:
1411: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,

Line 1417: FROM pay_assignment_actions paa,

1413: c_start_date in date,
1414: c_end_date in date)
1415: IS
1416: SELECT count(paa.assignment_action_id)
1417: FROM pay_assignment_actions paa,
1418: pay_payroll_actions ppa,
1419: per_assignments_f paf
1420: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
1421: AND ppa.business_group_id = c_business_group_id