DBA Data[Home] [Help]

APPS.HXT_HXT956D_XMLP_PKG dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

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