APPS.PAY_AE_CHEQUE_REPORT dependencies on PER_ALL_PEOPLE_F

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

73:
74:
75: CURSOR csr_get_assact_det_ORG (l_pact_id number , l_date date) IS
76: select paa.assignment_action_id , paa.assignment_id
77: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
78: where paa.payroll_action_id = p_pact_id
79: and paa.action_status = 'C'
80: and not exists ( select 1
81: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

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

98: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by emp no*/
99:
100: CURSOR csr_get_assact_det_EMPNO (l_pact_id number , l_date date) IS
101: select paa.assignment_action_id , paa.assignment_id
102: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
103: where paa.payroll_action_id = p_pact_id
104: and paa.action_status = 'C'
105: and not exists ( select 1
106: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 125: per_all_people_f ppf, per_all_assignments_f paf

121:
122: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
123: select paa.assignment_action_id , paa.assignment_id
124: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
125: per_all_people_f ppf, per_all_assignments_f paf
126: where paa.payroll_action_id = p_pact_id
127: and paa.action_status = 'C'
128: and not exists ( select 1
129: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 153: FROM per_all_people_f ppf, per_all_assignments_f paf

149: /* Cursor for fetching the details for the assignments */
150:
151: CURSOR csr_get_per_det (l_assignment_id number , l_date date) IS
152: SELECT ppf.full_name , ppf.employee_number , paf.job_id , paf.organization_id
153: FROM per_all_people_f ppf, per_all_assignments_f paf
154: WHERE paf.assignment_id = l_assignment_id
155: AND paf.person_id = ppf.person_id
156: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
157: AND trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date;