DBA Data[Home] [Help]

APPS.IGS_EN_GEN_009 dependencies on IGS_FI_GOV_HEC_PA_OP

Line 2158: FROM IGS_FI_GOV_HEC_PA_OP ghpo

2154: CURSOR c_ghpo_exempt (
2155: cp_govt_hecs_payment_option
2156: IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE) IS
2157: SELECT 'x'
2158: FROM IGS_FI_GOV_HEC_PA_OP ghpo
2159: WHERE ghpo.govt_hecs_payment_option = cp_govt_hecs_payment_option AND
2160: ghpo.s_hecs_payment_type = 'EXEMPT';
2161: v_is_exempt VARCHAR2(1);
2162: -- ensure that NULL end date is the max value.