DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 2280: pay_element_links_f pel,

2276: select pev.screen_entry_value sev, pev.element_entry_id eei
2277: from pay_element_entry_values_f pev,
2278: pay_input_values_f piv,
2279: pay_element_types_f pet,
2280: pay_element_links_f pel,
2281: pay_element_entries_f pee
2282: where pee.assignment_id = p_assignment
2283: and pel.element_link_id = pee.element_link_id
2284: and pet.element_type_id = pel.element_type_id

Line 2301: pay_element_links_f pel,

2297: pev.effective_end_date
2298: from pay_element_entry_values_f pev,
2299: pay_input_values_f piv,
2300: pay_element_types_f pet,
2301: pay_element_links_f pel,
2302: pay_element_entries_f pef
2303: where pef.element_entry_id = p_element_entry_id
2304: and pel.element_link_id = pef.element_link_id
2305: and pet.element_type_id = pel.element_type_id

Line 2368: pay_element_links_f pel,

2364: and pev.screen_entry_value is not null
2365: and pev.input_value_id = (select distinct piv.input_value_id
2366: from pay_input_values_f piv,
2367: pay_element_types_f pet,
2368: pay_element_links_f pel,
2369: pay_element_entries_f pef
2370: where pef.element_entry_id =
2371: l_prev_eleid
2372: and pel.element_link_id =

Line 2708: pay_element_links_f pel,

2704: pay_element_entry_values_f pev2,
2705: pay_input_values_f piv1,
2706: pay_element_entry_values_f pev1,
2707: pay_element_types_f pet,
2708: pay_element_links_f pel,
2709: pay_element_entries_f pef
2710: WHERE pef.assignment_id = p_assign_id
2711: AND pef.creator_type = 'UT'
2712: AND pef.element_link_id = pel.element_link_id