APPS.HRI_OLTP_DISC_RCTMNT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 20: FROM hr_all_organization_units b,

16: BEGIN
17: --
18: SELECT COUNT(p.person_id)
19: INTO l_v_hires
20: FROM hr_all_organization_units b,
21: per_requisitions r,
22: per_all_vacancies v,
23: per_all_assignments_f a,
24: per_all_people_f p

Line 69: FROM hr_all_organization_units b,

65: BEGIN
66: --
67: SELECT COUNT(p.person_id)
68: INTO l_v_offers
69: FROM hr_all_organization_units b,
70: per_assignment_status_types ast,
71: per_requisitions r,
72: per_all_vacancies v,
73: per_all_assignments_f a,

Line 122: FROM hr_all_organization_units b,

118: BEGIN
119: --
120: SELECT COUNT(p.person_id)
121: INTO l_ra_hires
122: FROM hr_all_organization_units b,
123: per_recruitment_activities r,
124: per_all_assignments_f a,
125: per_all_people_f p
126: WHERE TRUNC(SYSDATE) BETWEEN p.effective_start_date

Line 167: FROM hr_all_organization_units b,

163: BEGIN
164: --
165: SELECT COUNT(p.person_id)
166: INTO l_ra_offers
167: FROM hr_all_organization_units b,
168: per_assignment_status_types ast,
169: per_recruitment_activities r,
170: per_all_assignments_f a,
171: per_all_people_f p

Line 218: FROM hr_all_organization_units b,

214: BEGIN
215: --
216: SELECT COUNT(p.person_id)
217: INTO l_rav_hires
218: FROM hr_all_organization_units b,
219: per_all_vacancies v,
220: per_recruitment_activities r,
221: per_all_assignments_f a,
222: per_all_people_f p

Line 268: FROM hr_all_organization_units b,

264: BEGIN
265: --
266: SELECT COUNT(p.person_id)
267: INTO l_rav_offers
268: FROM hr_all_organization_units b,
269: per_assignment_status_types ast,
270: per_all_vacancies v,
271: per_recruitment_activities r,
272: per_all_assignments_f a,