APPS.PAY_AU_TERMINATIONS dependencies on PAY_PAYROLL_ACTIONS

Line 544: , pay_payroll_actions PAY_ACTION

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
548: and pay_action.payroll_id = period.payroll_id

Line 1316: ,pay_payroll_actions ppa

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
1320: AND paa.action_sequence in

Line 1324: pay_payroll_actions ppa,

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
1328: AND paa.assignment_id = paaf.assignment_id

Line 1346: ,pay_payroll_actions ppa

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
1350: AND paa.action_sequence in

Line 1354: pay_payroll_actions ppa,

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
1358: AND paa.assignment_id = paaf.assignment_id

Line 1406: FROM pay_payroll_actions ppa,

1402:
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:

Line 1418: pay_payroll_actions ppa,

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
1422: AND ppa.payroll_action_id = paa.payroll_action_id