APPS.BEN_ELEMENT_ENTRY dependencies on PAY_ELEMENT_TYPES_F

Line 2540: pay_element_types_f elt

2536: ele.creator_id,
2537: ele.creator_type
2538: from pay_element_entries_f ele,
2539: pay_element_links_f elk,
2540: pay_element_types_f elt
2541: where ele.effective_start_date = (select min(ele2.effective_start_date)
2542: from pay_element_entries_f ele2
2543: where ele2.element_entry_id
2544: = ele.element_entry_id)

Line 2895: from pay_element_types_f pet

2891: p_effective_date in date) is
2892: select pet.element_name,
2893: pet.multiple_entries_allowed_flag,
2894: pet.processing_type
2895: from pay_element_types_f pet
2896: where pet.element_type_id = p_element_type_id
2897: and p_effective_date between pet.effective_start_date
2898: and pet.effective_end_date;
2899: --

Line 3168: pay_element_types_f et,

3164: SELECT /*+ LEADING(ee)
3165: INDEX(ee pay_element_entries_f_n51) */
3166: ee.*
3167: FROM pay_element_entries_f ee,
3168: pay_element_types_f et,
3169: pay_element_links_f el,
3170: pay_element_entry_values_f ev
3171: WHERE el.element_link_id = ee.element_link_id
3172: AND el.element_link_id = l_elem_link_id

Line 7245: pay_element_types_f pet,

7241: pel.element_type_id,
7242: pev.input_value_id
7243: from per_all_assignments_f asg,
7244: pay_element_links_f pel,
7245: pay_element_types_f pet,
7246: pay_element_entries_f pee,
7247: pay_element_entry_values_f pev
7248: where asg.person_id = p_person_id
7249: and asg.assignment_id = pee.assignment_id

Line 8652: from pay_element_types_f pet,

8648: pel.element_type_id,
8649: pev.input_value_id,
8650: pet.element_name,
8651: pet.processing_type
8652: from pay_element_types_f pet,
8653: pay_element_links_f pel,
8654: pay_element_entries_f pee,
8655: pay_element_entry_values_f pev
8656: where pev.element_entry_value_id = p_element_entry_value_id

Line 10488: from pay_element_types_f

10484: and input_value_id = p_input_value_id;
10485: --
10486: cursor c_ety is
10487: select processing_type
10488: from pay_element_types_f
10489: where element_type_id = p_element_type_id
10490: and p_effective_date between effective_start_date
10491: and effective_end_date ;
10492: --

Line 10654: pay_element_types_f elt

10650: elk.effective_end_date
10651: from pay_element_entry_values_f elv,
10652: pay_element_entries_f ele,
10653: pay_element_links_f elk,
10654: pay_element_types_f elt
10655: where elv.element_entry_value_id = p_element_entry_value_id
10656: and elv.element_entry_id = ele.element_entry_id
10657: and elv.effective_start_date between ele.effective_start_date
10658: and ele.effective_end_date