APPS.PAY_SA_CHEQUE_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

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 194: FROM hr_all_organization_units

190:
191: /* Cursor for fetching the Organization name */
192: CURSOR csr_org (l_org_id number,l_date date) IS
193: SELECT name
194: FROM hr_all_organization_units
195: WHERE organization_id = l_org_id
196: AND trunc(l_date,'MM') between date_from and nvl(date_to, to_date('31/12/4712','DD/MM/YYYY'));
197:
198: /* Cursor for fetching the payment date of the pre payment for cheques */