APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 843: FROM pay_assignment_actions paa

839: CURSOR csr_chk_new_emp (c_assignment_id number)IS
840: SELECT 'N'
841: FROM dual
842: WHERE EXISTS(SELECT NULL
843: FROM pay_assignment_actions paa
844: ,pay_payroll_actions ppa
845: ,pay_run_results prr
846: ,pay_run_result_values prv
847: ,pay_element_types_f petf

Line 921: FROM pay_assignment_actions paa

917: --
918: CURSOR csr_get_assignment_action(c_assignment_id NUMBER
919: ,c_effective_date DATE) IS
920: SELECT paa.assignment_action_id
921: FROM pay_assignment_actions paa
922: ,pay_payroll_actions ppa
923: ,pay_run_results prr
924: ,pay_run_result_values prv
925: ,pay_element_types_f petf

Line 949: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

945: AND c_effective_date BETWEEN pivf.effective_start_date
946: AND pivf.effective_end_date
947: ORDER BY ppa.effective_date DESC;
948: --
949: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
950: l_result_value pay_run_result_values.result_value%TYPE;
951: --
952: BEGIN
953: --

Line 1008: ,pay_assignment_actions paa

1004: ,c_effective_date DATE) IS
1005: SELECT pap.full_name
1006: FROM per_all_people_f pap
1007: ,per_All_assignments_f paaf
1008: ,pay_assignment_actions paa
1009: WHERE paa.payroll_action_id = c_payroll_action_id
1010: AND paa.assignment_id = paaf.assignment_id
1011: AND paaf.person_id = pap.person_id
1012: AND paa.source_action_id IS NULL

Line 1092: ,pay_assignment_actions paa

1088: ,ppa.effective_date
1089: ,paa.action_status
1090: ,prtf.shortname
1091: FROM pay_payroll_actions ppa
1092: ,pay_assignment_actions paa
1093: ,per_all_assignments_f paaf
1094: ,pay_run_types_f prtf
1095: WHERE ppa.payroll_action_id = p_payroll_action_id
1096: AND ppa.payroll_action_id = paa.payroll_action_id