APPS.PAY_NO_ABSENCE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 141: ,PAY_ASSIGNMENT_ACTIONS PASG

137: CURSOR CSR_CUR_ABS_PRORATED (P_ASSIGNMENT_ID NUMBER, P_EFFECTIVE_DATE DATE, P_ST_DT DATE, P_EN_DT DATE) IS
138: SELECT DATE_EARNED
139: FROM PER_ALL_ASSIGNMENTS_F PAA
140: ,PAY_PAYROLL_ACTIONS PPA
141: ,PAY_ASSIGNMENT_ACTIONS PASG
142: WHERE PAA.PAYROLL_ID = PPA.PAYROLL_ID
143: AND PAA.ASSIGNMENT_ID = P_ASSIGNMENT_ID
144: AND PAA.ASSIGNMENT_ID = PASG.ASSIGNMENT_ID
145: AND PPA.PAYROLL_ACTION_ID = PASG.PAYROLL_ACTION_ID

Line 7280: ,PAY_ASSIGNMENT_ACTIONS PAA

7276: ,PAA.ASSIGNMENT_ID
7277: INTO l_effective_date
7278: ,l_assignment_id
7279: FROM PAY_PAYROLL_ACTIONS PPA
7280: ,PAY_ASSIGNMENT_ACTIONS PAA
7281: WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
7282: AND PAA.ASSIGNMENT_ACTION_ID = P_ASSIGNMENT_ACTION_ID;
7283: EXCEPTION
7284: WHEN NO_DATA_FOUND THEN

Line 7495: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7491:
7492: --
7493: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7494: SELECT pap.person_id FROM
7495: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7496: WHERE paa.assignment_action_id = p_assignment_action_id
7497: AND paa.assignment_id = asgmt.assignment_id
7498: AND asgmt.person_id = pap.person_id;
7499:

Line 7579: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7575:
7576: --
7577: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7578: SELECT pap.person_id FROM
7579: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7580: WHERE paa.assignment_action_id = p_assignment_action_id
7581: AND paa.assignment_id = asgmt.assignment_id
7582: AND asgmt.person_id = pap.person_id;
7583:

Line 8006: , pay_assignment_actions ASSACT

8002: count(TARGET.result_value )
8003: FROM pay_run_result_values TARGET
8004: , pay_balance_feeds_f FEED
8005: , pay_run_results RR
8006: , pay_assignment_actions ASSACT
8007: , pay_assignment_actions BAL_ASSACT
8008: , pay_payroll_actions PACT
8009: , pay_payroll_actions BACT
8010: where BAL_ASSACT.assignment_action_id = l_assignment_action_id

Line 8007: , pay_assignment_actions BAL_ASSACT

8003: FROM pay_run_result_values TARGET
8004: , pay_balance_feeds_f FEED
8005: , pay_run_results RR
8006: , pay_assignment_actions ASSACT
8007: , pay_assignment_actions BAL_ASSACT
8008: , pay_payroll_actions PACT
8009: , pay_payroll_actions BACT
8010: where BAL_ASSACT.assignment_action_id = l_assignment_action_id
8011: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id