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