DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 561: pay_element_types_f pet

557: SELECT DISTINCT pee.assignment_id ,
558: pet.proration_group_id
559: into p_assignment_id,p_event_group_id
560: FROM pay_element_entries_f pee,
561: pay_element_types_f pet
562: WHERE pee.element_entry_id = p_element_entry_id
563: AND pee.element_type_id = pet.element_type_id
564: AND pee.effective_start_date <= l_date_earned
565: AND pee.effective_end_date >= time_fn(p_assignment_action_id,

Line 5920: ,pay_element_types_f et

5916: select distinct(et.recalc_event_group_id) recalc_event_group_id
5917: from
5918: pay_element_entries_f ee
5919: ,pay_element_links_f el
5920: ,pay_element_types_f et
5921: where ee.element_entry_id = nvl(cp_ee_id,-1)
5922: and ee.element_link_id = el.element_link_id
5923: and el.element_type_id = et.element_type_id
5924: and cp_report_date between et.effective_start_date