APPS.HR_PERSON_DELETE dependencies on PAY_ELEMENT_LINKS_F

Line 449: pay_element_links_f l

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

Line 976: pay_element_links_f l

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