APPS.HR_PERSON_DELETE dependencies on PAY_ELEMENT_LINKS_F

Line 448: pay_element_links_f l

444: e.effective_end_date,
445: a.assignment_id
446: from pay_element_entries_f e,
447: per_assignments_f a,
448: pay_element_links_f l
449: where a.person_id = P_PERSON_ID
450: and a.assignment_id = e.assignment_id
451: and e.effective_start_date between
452: a.effective_start_date and a.effective_end_date

Line 975: pay_element_links_f l

971: where not exists (
972: select null
973: from pay_element_entries_f e,
974: per_assignments_f a,
975: pay_element_links_f l
976: where a.person_id = P_PERSON_ID
977: and a.assignment_id = e.assignment_id
978: and e.element_link_id = l.element_link_id
979: and l.standard_link_flag = 'N');