DBA Data[Home] [Help]

APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PAY_ELEMENT_TYPES_F

Line 1026: FROM pay_element_types_f pet, pay_element_types_f_tl petl

1022: --
1023: BEGIN
1024: SELECT petl.element_name
1025: INTO l_element_name
1026: FROM pay_element_types_f pet, pay_element_types_f_tl petl
1027: WHERE pet.element_type_id = p_ele_type_id
1028: AND petl.element_type_id = pet.element_type_id
1029: AND USERENV ('LANG') = petl.LANGUAGE
1030: AND p_effective_date BETWEEN pet.effective_start_date

Line 2048: FROM pay_element_types_f pet

2044: --
2045: BEGIN
2046: SELECT pet.element_type_id
2047: INTO l_ele_type_id
2048: FROM pay_element_types_f pet
2049: WHERE pet.element_name = p_element_name
2050: AND ( pet.business_group_id + 0 = p_bg_id
2051: OR pet.business_group_id IS NULL
2052: )