APPS.PAY_KW_CHEQUE_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 70: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou

66:
67: /*
68: CURSOR csr_get_assact_det_ORG (l_pact_id number , l_date date) IS
69: select paa.assignment_action_id , paa.assignment_id
70: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou
71: where paa.payroll_action_id = p_pact_id
72: and paa.action_status = 'C'
73: and not exists ( select 1
74: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 90: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf

86: */
87:
88: CURSOR csr_get_assact_det_ORG (l_pact_id number , l_date date) IS
89: select paa.assignment_action_id , paa.assignment_id
90: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
91: where paa.payroll_action_id = p_pact_id
92: and paa.action_status = 'C'
93: and not exists ( select 1
94: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 114: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf

110: /*** ORDER BY EMPNO ***/
111: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by emp no*/
112: CURSOR csr_get_assact_det_EMPNO (l_pact_id number , l_date date) IS
113: select paa.assignment_action_id , paa.assignment_id
114: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
115: where paa.payroll_action_id = p_pact_id
116: and paa.action_status = 'C'
117: and not exists ( select 1
118: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 161: per_all_people_f ppf, per_all_assignments_f paf

157:
158: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
159: select paa.assignment_action_id , paa.assignment_id
160: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
161: per_all_people_f ppf, per_all_assignments_f paf
162: where paa.payroll_action_id = p_pact_id
163: and paa.action_status IN ('C','S') -- 10375683
164: and not exists ( select 1
165: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 188: FROM per_all_people_f ppf, per_all_assignments_f paf

184:
185: /* Cursor for fetching the details for the assignments */
186: CURSOR csr_get_per_det (l_assignment_id number , l_date date) IS
187: SELECT ppf.full_name , ppf.employee_number , paf.job_id , paf.organization_id
188: FROM per_all_people_f ppf, per_all_assignments_f paf
189: WHERE paf.assignment_id = l_assignment_id
190: AND paf.person_id = ppf.person_id
191: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
192: AND trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date;