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 6269: ,pay_element_types_f et

6265: select distinct(et.recalc_event_group_id) recalc_event_group_id
6266: from
6267: pay_element_entries_f ee
6268: ,pay_element_links_f el
6269: ,pay_element_types_f et
6270: where ee.element_entry_id = nvl(cp_ee_id,-1)
6271: and ee.element_link_id = el.element_link_id
6272: and el.element_type_id = et.element_type_id
6273: and cp_report_date between et.effective_start_date