DBA Data[Home] [Help]

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 1186: pay_element_links_f l

1182: where not exists (
1183: select null
1184: from pay_element_entries_f e,
1185: per_assignments_f a,
1186: pay_element_links_f l
1187: where a.person_id = P_PERSON_ID
1188: and a.assignment_id = e.assignment_id
1189: and e.element_link_id = l.element_link_id
1190: and l.standard_link_flag = 'N');