DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_RCTMNT dependencies on PER_ALL_PEOPLE_F

Line 24: per_all_people_f p

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
25: WHERE TRUNC(SYSDATE) BETWEEN p.effective_start_date
26: AND p.effective_end_date
27: /* bug 2033292 */
28: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date

Line 74: per_all_people_f p

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
75: WHERE TRUNC(SYSDATE) BETWEEN p.effective_start_date
76: AND p.effective_end_date
77: /* bug 2033292 */
78: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date

Line 125: per_all_people_f p

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
127: AND p.effective_end_date
128: /* bug 2033292 */
129: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date

Line 171: per_all_people_f p

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
173: AND p.effective_end_date
174: /* bug 2033292 */
175: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date

Line 222: per_all_people_f p

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
223: WHERE TRUNC(SYSDATE) BETWEEN p.effective_start_date
224: AND p.effective_end_date
225: /* bug 2033292 */
226: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date

Line 273: per_all_people_f p

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
274: WHERE TRUNC(SYSDATE) BETWEEN p.effective_start_date
275: AND p.effective_end_date
276: /* bug 2033292 */
277: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date