[Home] [Help]
APPS.IGS_AD_GEN_005 dependencies on IGS_FI_HECS_PAY_OPTN
Line 246: IGS_FI_HECS_PAY_OPTN hpo
242: cp_admission_cat IGS_AD_CT_HECS_PAYOP.admission_cat%TYPE) IS
243: SELECT achpo.hecs_payment_option,
244: hpo.description
245: FROM IGS_AD_CT_HECS_PAYOP achpo,
246: IGS_FI_HECS_PAY_OPTN hpo
247: WHERE achpo.admission_cat = cp_admission_cat AND
248: 1 = (
249: SELECT count(*)
250: FROM IGS_AD_CT_HECS_PAYOP achpo