DBA Data[Home] [Help]

APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PAY_ELEMENT_TYPES_F

Line 524: FROM pay_element_types_f pet, pay_element_types_f_tl petl

520: --
521: BEGIN
522: SELECT petl.element_name
523: INTO l_element_name
524: FROM pay_element_types_f pet, pay_element_types_f_tl petl
525: WHERE pet.element_type_id = p_ele_type_id
526: AND petl.element_type_id = pet.element_type_id
527: AND USERENV ('LANG') = petl.LANGUAGE
528: AND p_effective_date BETWEEN pet.effective_start_date

Line 1453: FROM pay_element_types_f pet

1449: --
1450: BEGIN
1451: SELECT pet.element_type_id
1452: INTO l_ele_type_id
1453: FROM pay_element_types_f pet
1454: WHERE pet.element_name = p_element_name
1455: AND ( pet.business_group_id + 0 = p_bg_id
1456: OR pet.business_group_id IS NULL
1457: )