APPS.HR_INPUT_VALUES dependencies on PAY_ELEMENT_LINKS_F

Line 90: from pay_element_links_f el,

86: into v_validation_check
87: from sys.dual
88: where exists
89: (select 1
90: from pay_element_links_f el,
91: pay_element_entries_f ee
92: where p_element_type_id = el.element_type_id
93: and el.element_link_id = ee.element_link_id
94: and ee.effective_end_date >= p_val_start_date

Line 619: from pay_element_links_f el,

615: into v_links_exist_flag
616: from sys.dual
617: where exists
618: (select 1
619: from pay_element_links_f el,
620: pay_input_values_f_tl ip_tl,
621: pay_input_values_f ip
622: where ip_tl.input_value_id = ip.input_value_id
623: and ip.input_value_id = p_input_value_id

Line 974: from pay_element_links_f el,

970: into v_entries_exist_flag
971: from sys.dual
972: where exists
973: (select 1
974: from pay_element_links_f el,
975: pay_element_entries_f ee
976: where p_element_type_id = el.element_type_id
977: and el.element_link_id = ee.element_link_id
978: and el.effective_start_date <= p_val_end_date

Line 1203: from pay_element_links_F el

1199: -1,
1200: -1,
1201: -1,
1202: sysdate
1203: from pay_element_links_F el
1204: where p_element_type_id = el.element_type_id
1205: and el.effective_start_date <= p_validation_end_date
1206: and el.effective_end_date >= p_validation_start_date;
1207: