DBA Data[Home] [Help]

APPS.HXT_HXT956E_XMLP_PKG dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

Line 13: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV1

9: CURSOR C IS
10: SELECT ELTT.ELEMENT_NAME
11: FROM PAY_ELEMENT_TYPES_F ELT1
12: ,PAY_ELEMENT_TYPES_F_TL ELTT
13: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV1
14: WHERE ELTV1.ELEMENT_TYPE_ID = P_ELT_PRIOR_PREM_ID
15: AND ELTV1.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
16: AND ELTV1.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
17: AND ELTV1.ELEMENT_TYPE_ID = ELT1.ELEMENT_TYPE_ID

Line 83: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV

79: CURSOR C IS
80: SELECT ELTT.ELEMENT_NAME
81: FROM PAY_ELEMENT_TYPES_F ELT
82: ,PAY_ELEMENT_TYPES_F_TL ELTT
83: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
84: WHERE ELTV.ELEMENT_TYPE_ID = P_ELT_EARNED_PREM_ID
85: AND ELTV.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
86: AND ELTV.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
87: AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID