APPS.PAY_SA_CHEQUE_REPORT dependencies on PER_ALL_PEOPLE_F

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

83: /*** ORDER BY ORG ***/
84: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by org name */
85: CURSOR csr_get_assact_det_ORG (l_pact_id number , l_date date) IS
86: select paa.assignment_action_id , paa.assignment_id
87: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
88: where paa.payroll_action_id = p_pact_id
89: and paa.action_status = 'C'
90: and not exists ( select 1
91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

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

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

Line 132: per_all_people_f ppf, per_all_assignments_f paf

128: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by payment date*/
129: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
130: select paa.assignment_action_id , paa.assignment_id
131: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
132: per_all_people_f ppf, per_all_assignments_f paf
133: where paa.payroll_action_id = p_pact_id
134: and paa.action_status = 'C'
135: and not exists ( select 1
136: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 159: FROM per_all_people_f ppf, per_all_assignments_f paf

155:
156: /* Cursor for fetching the details for the assignments */
157: CURSOR csr_get_per_det (l_assignment_id number , l_date date) IS
158: SELECT ppf.full_name , ppf.employee_number , paf.job_id , paf.organization_id
159: FROM per_all_people_f ppf, per_all_assignments_f paf
160: WHERE paf.assignment_id = l_assignment_id
161: AND paf.person_id = ppf.person_id
162: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
163: AND trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date;