APPS.PAY_KW_CHEQUE_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

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

219:
220: /* Cursor for fetching the Organization name */
221: CURSOR csr_org (l_org_id number,l_date date) IS
222: SELECT name
223: FROM hr_all_organization_units
224: WHERE organization_id = l_org_id
225: AND trunc(l_date,'MM') between date_from and nvl(date_to, to_date('31/12/4712','DD/MM/YYYY'));
226:
227: /* Cursor for fetching the payment date of the pre payment for cheques */