DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1990: pay_element_links_f pel,

1986: select pev.screen_entry_value sev, pev.element_entry_id eei
1987: from pay_element_entry_values_f pev,
1988: pay_input_values_f piv,
1989: pay_element_types_f pet,
1990: pay_element_links_f pel,
1991: pay_element_entries_f pee
1992: where pee.assignment_id = p_assignment
1993: and pel.element_link_id = pee.element_link_id
1994: and pet.element_type_id = pel.element_type_id

Line 2011: pay_element_links_f pel,

2007: pev.effective_end_date
2008: from pay_element_entry_values_f pev,
2009: pay_input_values_f piv,
2010: pay_element_types_f pet,
2011: pay_element_links_f pel,
2012: pay_element_entries_f pef
2013: where pef.element_entry_id = p_element_entry_id
2014: and pel.element_link_id = pef.element_link_id
2015: and pet.element_type_id = pel.element_type_id

Line 2078: pay_element_links_f pel,

2074: and pev.screen_entry_value is not null
2075: and pev.input_value_id = (select distinct piv.input_value_id
2076: from pay_input_values_f piv,
2077: pay_element_types_f pet,
2078: pay_element_links_f pel,
2079: pay_element_entries_f pef
2080: where pef.element_entry_id =
2081: l_prev_eleid
2082: and pel.element_link_id =

Line 2415: pay_element_links_f pel,

2411: pay_element_entry_values_f pev2,
2412: pay_input_values_f piv1,
2413: pay_element_entry_values_f pev1,
2414: pay_element_types_f pet,
2415: pay_element_links_f pel,
2416: pay_element_entries_f pef
2417: WHERE pef.assignment_id = p_assign_id
2418: AND pef.creator_type = 'UT'
2419: AND pef.element_link_id = pel.element_link_id