DBA Data[Home] [Help]

APPS.HXT_HXT956E_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

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 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

Line 82: ,PAY_ELEMENT_TYPES_F_TL ELTT

78: DECLARE
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