DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_RCTMNT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 70: per_assignment_status_types ast,

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,
74: per_all_people_f p

Line 168: per_assignment_status_types ast,

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
172: WHERE TRUNC(SYSDATE) BETWEEN p.effective_start_date

Line 269: per_assignment_status_types ast,

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,
273: per_all_people_f p