DBA Data[Home] [Help]

APPS.PER_ES_ABSENCE dependencies on PAY_ELEMENT_TYPES_F

Line 29: ,pay_element_types_f petf

25: ,p_date DATE) IS
26: SELECT pivf.input_value_id iv_start_date_id
27: FROM pay_input_values_f pivf
28: ,pay_element_entries_f peef
29: ,pay_element_types_f petf
30: WHERE peef.element_entry_id = p_element_entry_id
31: AND peef.element_type_id = petf.element_type_id
32: AND pivf.element_type_id = petf.element_type_id
33: AND pivf.name = p_input_value_name

Line 195: ,pay_element_types_f petf

191: ,p_date DATE) IS
192: SELECT pivf.input_value_id iv_start_date_id
193: FROM pay_input_values_f pivf
194: ,pay_element_entries_f peef
195: ,pay_element_types_f petf
196: WHERE peef.element_entry_id = p_element_entry_id
197: AND peef.element_type_id = petf.element_type_id
198: AND pivf.element_type_id = petf.element_type_id
199: AND pivf.name = p_input_value_name