DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1989: pay_element_types_f pet,

1985: cursor csr_get_dup (p_assignment number) is
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

Line 2010: pay_element_types_f pet,

2006: select pev.screen_entry_value , pev.effective_start_date,
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

Line 2077: pay_element_types_f pet,

2073: where pev.element_entry_id = l_prev_eleid
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

Line 2414: pay_element_types_f pet,

2410: FROM pay_input_values_f piv2,
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'