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 7180: ,PAY_ASSIGNMENT_ACTIONS PAA

7176: ,PAA.ASSIGNMENT_ID
7177: INTO l_effective_date
7178: ,l_assignment_id
7179: FROM PAY_PAYROLL_ACTIONS PPA
7180: ,PAY_ASSIGNMENT_ACTIONS PAA
7181: WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
7182: AND PAA.ASSIGNMENT_ACTION_ID = P_ASSIGNMENT_ACTION_ID;
7183: EXCEPTION
7184: WHEN NO_DATA_FOUND THEN

Line 7395: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7391:
7392: --
7393: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7394: SELECT pap.person_id FROM
7395: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7396: WHERE paa.assignment_action_id = p_assignment_action_id
7397: AND paa.assignment_id = asgmt.assignment_id
7398: AND asgmt.person_id = pap.person_id;
7399:

Line 7479: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7475:
7476: --
7477: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7478: SELECT pap.person_id FROM
7479: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7480: WHERE paa.assignment_action_id = p_assignment_action_id
7481: AND paa.assignment_id = asgmt.assignment_id
7482: AND asgmt.person_id = pap.person_id;
7483: