DBA Data[Home] [Help]

APPS.HXT_HXT956C_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 11: FROM PAY_ELEMENT_TYPES_F ELT

7: earn_type := ' ';
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 ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
15: AND elt.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 ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
15: AND elt.effective_start_date <= arg_EFFECTIVE_START_DATE
16: and elt.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 ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
15: AND elt.effective_start_date <= arg_EFFECTIVE_START_DATE
16: and elt.effective_end_date >= arg_EFFECTIVE_END_DATE
17: AND HXT_EARNING_CATEGORY = 'SDF'