DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PAY_ELEMENT_TYPES_F

Line 753: from pay_element_types_f pet,

749: p_effective_date date) is
750: select petl.element_name,
751: pet.effective_start_date,
752: pet.effective_end_date
753: from pay_element_types_f pet,
754: pay_element_types_f_tl petl
755: where pet.element_type_id = p_element_type_id
756: and petl.element_type_id = pet.element_type_id
757: and p_user_language = petl.language

Line 754: pay_element_types_f_tl petl

750: select petl.element_name,
751: pet.effective_start_date,
752: pet.effective_end_date
753: from pay_element_types_f pet,
754: pay_element_types_f_tl petl
755: where pet.element_type_id = p_element_type_id
756: and petl.element_type_id = pet.element_type_id
757: and p_user_language = petl.language
758: and p_effective_date between pet.effective_start_date