DBA Data[Home] [Help]

APPS.HR_PAY_BASIS dependencies on PAY_ELEMENT_TYPES_F

Line 383: pay_element_types_f pet,

379: p_element_name,
380: p_element_type_id
381: from pay_input_values_f piv,
382: pay_input_values_f_tl pivtl,
383: pay_element_types_f pet,
384: pay_element_types_f_tl pettl
385: where pet.element_type_id = piv.element_type_id
386: and pet.element_type_id = pettl.element_type_id
387: and p_session_date between pet.effective_start_date

Line 384: pay_element_types_f_tl pettl

380: p_element_type_id
381: from pay_input_values_f piv,
382: pay_input_values_f_tl pivtl,
383: pay_element_types_f pet,
384: pay_element_types_f_tl pettl
385: where pet.element_type_id = piv.element_type_id
386: and pet.element_type_id = pettl.element_type_id
387: and p_session_date between pet.effective_start_date
388: and pet.effective_end_date