APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1040: FROM pay_element_entries_f pee,

1036:
1037: CURSOR pev_cur(geocode VARCHAR2, assign_id NUMBER) IS
1038: SELECT /*+ ORDERED */ distinct pev.screen_entry_value, pev.element_entry_id,
1039: pev.input_value_id
1040: FROM pay_element_entries_f pee,
1041: pay_element_entry_values_f pev,
1042: pay_input_values_f piv
1043: WHERE pee.assignment_id = assign_id
1044: AND pee.element_entry_id = pev.element_entry_id

Line 2281: pay_element_entries_f pee

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

Line 2302: pay_element_entries_f pef

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

Line 2369: pay_element_entries_f pef

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

Line 2396: delete pay_element_entries_f

2392: hr_utility.set_location('pay_us_geo_upd_pkg.duplicate_vertex_ee', 6);
2393:
2394: /* Now delete the current entry */
2395:
2396: delete pay_element_entries_f
2397: where element_entry_id = j.eei
2398: and assignment_id = p_assignment_id;
2399:
2400: hr_utility.set_location('pay_us_geo_upd_pkg.duplicate_vertex_ee', 7);

Line 2641: p_location => 'PAY_ELEMENT_ENTRIES_F',

2637: p_person_id => p_person_id,
2638: p_assign_id => p_assign_id,
2639: p_old_juri_code => null,
2640: p_new_juri_code => p_new_juri_code,
2641: p_location => 'PAY_ELEMENT_ENTRIES_F',
2642: p_id => null);
2643:
2644: hr_utility.set_location('pay_us_geo_upd_pkg.insert_ele_entries',13);
2645:

Line 2661: p_location => 'PAY_ELEMENT_ENTRIES_F',

2657: p_person_id => p_person_id,
2658: p_assign_id => p_assign_id,
2659: p_old_juri_code => null,
2660: p_new_juri_code => p_new_juri_code,
2661: p_location => 'PAY_ELEMENT_ENTRIES_F',
2662: p_id => null);
2663:
2664: END IF;
2665: END insert_ele_entries;

Line 2709: pay_element_entries_f pef

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