APPS.PAY_AE_CHEQUE_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

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

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