DBA Data[Home] [Help]

APPS.HXT_HXT956A_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 53: FROM PAY_ELEMENT_TYPES_F ELT

49: earn_type := ' ';
50: DECLARE
51: CURSOR C IS
52: SELECT ELTT.ELEMENT_NAME
53: FROM PAY_ELEMENT_TYPES_F ELT
54: ,PAY_ELEMENT_TYPES_F_TL ELTT
55: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
56: WHERE ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
57: AND ELTT.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID

Line 54: ,PAY_ELEMENT_TYPES_F_TL ELTT

50: DECLARE
51: CURSOR C IS
52: SELECT ELTT.ELEMENT_NAME
53: FROM PAY_ELEMENT_TYPES_F ELT
54: ,PAY_ELEMENT_TYPES_F_TL ELTT
55: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
56: WHERE ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
57: AND ELTT.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
58: AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID

Line 55: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV

51: CURSOR C IS
52: SELECT ELTT.ELEMENT_NAME
53: FROM PAY_ELEMENT_TYPES_F ELT
54: ,PAY_ELEMENT_TYPES_F_TL ELTT
55: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
56: WHERE ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
57: AND ELTT.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
58: AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
59: AND elt.effective_start_date <= arg_EFFECTIVE_START_DATE