APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 290: FROM pay_element_entries_f pee

286: -- CURSOR to get the element_entry_id
287: --
288: CURSOR c_ele_ent (c_element_type_id IN NUMBER)IS
289: SELECT pee.element_entry_id
290: FROM pay_element_entries_f pee
291: ,pay_element_links_f pel
292: WHERE pee.element_link_id = pel.element_link_id
293: AND pee.assignment_id = p_assignment_id
294: AND pel.element_type_id = c_element_type_id

Line 319: l_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;

315: AND rownum = 1;
316:
317: l_element_type_id PAY_ELEMENT_TYPES_F.element_type_id%TYPE;
318: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;
319: l_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;
320: l_ass_act NUMBER;
321:
322: BEGIN
323:

Line 6071: pay_element_entries_f pee

6067: SELECT fnd_number.canonical_to_number(nvl(screen_entry_value,'0')) perc_value
6068: ,pee.effective_start_date start_date
6069: ,pee.effective_end_date end_date
6070: FROM pay_element_entry_values_f pef,
6071: pay_element_entries_f pee
6072: WHERE pef.input_value_id = c_input_value_id
6073: AND pef.element_entry_id = pee.element_entry_id
6074: AND pef.effective_start_date = pee.effective_start_date
6075: AND pef.effective_end_date = pee.effective_end_date

Line 7262: pay_element_entries_f pee,

7258: peev2.screen_entry_value paid,
7259: pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id) orig_date_earned
7260: FROM pay_element_entry_values_f peev1,
7261: pay_element_entry_values_f peev2,
7262: pay_element_entries_f pee,
7263: pay_retro_component_usages prcu,
7264: pay_retro_components prc,
7265: pay_element_span_usages pesu
7266: WHERE (prc.component_name ='Adjustment' OR (prc.component_name ='Correction'