DBA Data[Home] [Help]

APPS.HR_ELEMENT_LINKS dependencies on PAY_ELEMENT_TYPES_F

Line 369: pay_element_types_f et

365: where es.element_set_id = p_element_set_id
366: and exists
367: (select 1
368: from pay_element_set_members esm,
369: pay_element_types_f et
370: where es.element_set_id = esm.element_set_id
371: and esm.element_type_id = et.element_type_id
372: and p_val_start_date between
373: et.effective_start_date and et.effective_end_date);

Line 528: from pay_element_types_f et,

524: into l_delete_ok
525: from sys.dual
526: where exists
527: (select 1
528: from pay_element_types_f et,
529: pay_element_entries_f ee,
530: pay_element_links_f el
531: where p_element_link_id = el.element_link_id
532: and el.element_type_id = et.element_type_id