APPS.HR_PERSON_INTERNAL dependencies on PAY_ELEMENT_LINKS_F

Line 228: pay_element_links_f l

224: SELECT l.element_type_id, e.effective_start_date,
225: e.effective_end_date, a.assignment_id
226: FROM pay_element_entries_f e,
227: per_assignments_f a,
228: pay_element_links_f l
229: WHERE a.person_id = P_PERSON_ID
230: and a.assignment_id = e.assignment_id
231: and e.effective_start_date between
232: a.effective_start_date and a.effective_end_date

Line 1157: pay_element_links_f l

1153: where not exists (
1154: select null
1155: from pay_element_entries_f e,
1156: per_assignments_f a,
1157: pay_element_links_f l
1158: where a.person_id = P_PERSON_ID
1159: and a.assignment_id = e.assignment_id
1160: and e.element_link_id = l.element_link_id
1161: and l.standard_link_flag = 'N');