DBA Data[Home] [Help]

APPS.HR_TERMINATION_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 229: ,per_all_assignments_f paf

225: ----------------------------------------------------------------------------
226: CURSOR csr_get_subordinate IS
227: SELECT ppf.person_id
228: FROM per_all_people_f ppf -- Bug 2130066 fix
229: ,per_all_assignments_f paf
230: ,per_periods_of_service ppos
231: WHERE paf.supervisor_id = l_number_value
232: AND paf.person_id = ppf.person_id
233: AND ppf.person_id = ppos.person_id

Line 247: ,per_all_assignments_f paf

243: ,l_effective_date)
244: UNION -- CWK Phase III Changes.
245: SELECT ppf.person_id
246: FROM per_all_people_f ppf -- Bug 2130066 fix
247: ,per_all_assignments_f paf
248: ,per_periods_of_placement ppop
249: WHERE paf.supervisor_id = l_number_value
250: AND paf.person_id = ppf.person_id
251: AND ppf.person_id = ppop.person_id