APPS.HXT_HXT956D_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 11: FROM PAY_ELEMENT_TYPES_F ELT

7: bht := ' ';
8: DECLARE
9: CURSOR C IS
10: SELECT ELTT.ELEMENT_NAME
11: FROM PAY_ELEMENT_TYPES_F ELT
12: ,PAY_ELEMENT_TYPES_F_TL ELTT
13: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
14: WHERE ELTV.ELEMENT_TYPE_ID = ELT_BASE_ID
15: AND ELTV.EFFECTIVE_START_DATE <= arg_effective_start_date

Line 12: ,PAY_ELEMENT_TYPES_F_TL ELTT

8: DECLARE
9: CURSOR C IS
10: SELECT ELTT.ELEMENT_NAME
11: FROM PAY_ELEMENT_TYPES_F ELT
12: ,PAY_ELEMENT_TYPES_F_TL ELTT
13: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
14: WHERE ELTV.ELEMENT_TYPE_ID = ELT_BASE_ID
15: AND ELTV.EFFECTIVE_START_DATE <= arg_effective_start_date
16: AND ELTV.EFFECTIVE_END_DATE >= arg_effective_end_date

Line 13: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV

9: CURSOR C IS
10: SELECT ELTT.ELEMENT_NAME
11: FROM PAY_ELEMENT_TYPES_F ELT
12: ,PAY_ELEMENT_TYPES_F_TL ELTT
13: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
14: WHERE ELTV.ELEMENT_TYPE_ID = ELT_BASE_ID
15: AND ELTV.EFFECTIVE_START_DATE <= arg_effective_start_date
16: AND ELTV.EFFECTIVE_END_DATE >= arg_effective_end_date
17: AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID

Line 51: FROM PAY_ELEMENT_TYPES_F ELT1

47: prem := ' ';
48: DECLARE
49: CURSOR C IS
50: SELECT ELTT.ELEMENT_NAME
51: FROM PAY_ELEMENT_TYPES_F ELT1
52: ,pay_element_types_f_tl eltt
53: WHERE ELT1.ELEMENT_TYPE_ID = ELT_PREMIUM_ID
54: AND ELT1.element_type_id = eltt.element_type_id
55: AND eltt.language = userenv('LANG');

Line 52: ,pay_element_types_f_tl eltt

48: DECLARE
49: CURSOR C IS
50: SELECT ELTT.ELEMENT_NAME
51: FROM PAY_ELEMENT_TYPES_F ELT1
52: ,pay_element_types_f_tl eltt
53: WHERE ELT1.ELEMENT_TYPE_ID = ELT_PREMIUM_ID
54: AND ELT1.element_type_id = eltt.element_type_id
55: AND eltt.language = userenv('LANG');
56: BEGIN