DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PAY_ELEMENT_TYPES_F

Line 748: from pay_element_types_f pet,

744: p_effective_date date) is
745: select petl.element_name,
746: pet.effective_start_date,
747: pet.effective_end_date
748: from pay_element_types_f pet,
749: pay_element_types_f_tl petl
750: where pet.element_type_id = p_element_type_id
751: and petl.element_type_id = pet.element_type_id
752: and p_user_language = petl.language

Line 749: pay_element_types_f_tl petl

745: select petl.element_name,
746: pet.effective_start_date,
747: pet.effective_end_date
748: from pay_element_types_f pet,
749: pay_element_types_f_tl petl
750: where pet.element_type_id = p_element_type_id
751: and petl.element_type_id = pet.element_type_id
752: and p_user_language = petl.language
753: and p_effective_date between pet.effective_start_date