APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 831: FROM pay_element_entries_f pee,

827:
828: CURSOR pev_cur(geocode VARCHAR2, assign_id NUMBER) IS
829: SELECT /*+ ORDERED */ distinct pev.screen_entry_value, pev.element_entry_id,
830: pev.input_value_id
831: FROM pay_element_entries_f pee,
832: pay_element_entry_values_f pev,
833: pay_input_values_f piv
834: WHERE pee.assignment_id = assign_id
835: AND pee.element_entry_id = pev.element_entry_id

Line 1991: pay_element_entries_f pee

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
1995: and pet.element_name = 'VERTEX'

Line 2012: pay_element_entries_f pef

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
2016: and pet.element_name = 'VERTEX'

Line 2079: pay_element_entries_f pef

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 =
2083: pef.element_link_id

Line 2103: delete pay_element_entries_f

2099: hr_utility.set_location('pay_us_geo_upd_pkg.duplicate_vertex_ee', 6);
2100:
2101: /* Now delete the current entry */
2102:
2103: delete pay_element_entries_f
2104: where element_entry_id = j.eei
2105: and assignment_id = p_assignment_id;
2106:
2107: hr_utility.set_location('pay_us_geo_upd_pkg.duplicate_vertex_ee', 7);

Line 2348: p_location => 'PAY_ELEMENT_ENTRIES_F',

2344: p_person_id => p_person_id,
2345: p_assign_id => p_assign_id,
2346: p_old_juri_code => null,
2347: p_new_juri_code => p_new_juri_code,
2348: p_location => 'PAY_ELEMENT_ENTRIES_F',
2349: p_id => null);
2350:
2351: hr_utility.set_location('pay_us_geo_upd_pkg.insert_ele_entries',13);
2352:

Line 2368: p_location => 'PAY_ELEMENT_ENTRIES_F',

2364: p_person_id => p_person_id,
2365: p_assign_id => p_assign_id,
2366: p_old_juri_code => null,
2367: p_new_juri_code => p_new_juri_code,
2368: p_location => 'PAY_ELEMENT_ENTRIES_F',
2369: p_id => null);
2370:
2371: END IF;
2372: END insert_ele_entries;

Line 2416: pay_element_entries_f pef

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
2420: AND pel.element_type_id = pet.element_type_id