DBA Data[Home] [Help]

APPS.HXT_HXT957A_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 26: FROM PAY_ELEMENT_TYPES_F ELT

22: earn_type := ' ';
23: DECLARE
24: CURSOR C IS
25: SELECT ELTT.ELEMENT_NAME
26: FROM PAY_ELEMENT_TYPES_F ELT
27: ,PAY_ELEMENT_TYPES_F_TL ELTT
28: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
29: WHERE ELT.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
30: AND elt.effective_start_date <= P_EFFECTIVE_START_DATE

Line 27: ,PAY_ELEMENT_TYPES_F_TL ELTT

23: DECLARE
24: CURSOR C IS
25: SELECT ELTT.ELEMENT_NAME
26: FROM PAY_ELEMENT_TYPES_F ELT
27: ,PAY_ELEMENT_TYPES_F_TL ELTT
28: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
29: WHERE ELT.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
30: AND elt.effective_start_date <= P_EFFECTIVE_START_DATE
31: and elt.effective_end_date >= P_EFFECTIVE_END_DATE

Line 28: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV

24: CURSOR C IS
25: SELECT ELTT.ELEMENT_NAME
26: FROM PAY_ELEMENT_TYPES_F ELT
27: ,PAY_ELEMENT_TYPES_F_TL ELTT
28: ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
29: WHERE ELT.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
30: AND elt.effective_start_date <= P_EFFECTIVE_START_DATE
31: and elt.effective_end_date >= P_EFFECTIVE_END_DATE
32: AND eltv.effective_start_date <= P_EFFECTIVE_START_DATE