eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 2279: pay_element_types_f pet,

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

Line 2300: pay_element_types_f pet,

2296: select /*Bug 7592909*/distinct pev.screen_entry_value , pev.effective_start_date,
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

Line 2367: pay_element_types_f pet,

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

Line 2707: pay_element_types_f pet,

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