APPS.IGS_AD_GEN_005 dependencies on IGS_AD_CT_HECS_PAYOP

Line 240: v_hecs_payment_option IGS_AD_CT_HECS_PAYOP.hecs_payment_option%TYPE;

236: -- is mapped to the admission category.
237: -- If no default value exists the routine returns a null value.
238: -- The default value must not be closed.
239: DECLARE
240: v_hecs_payment_option IGS_AD_CT_HECS_PAYOP.hecs_payment_option%TYPE;
241: CURSOR c_achpo (
242: cp_admission_cat IGS_AD_CT_HECS_PAYOP.admission_cat%TYPE) IS
243: SELECT achpo.hecs_payment_option,
244: hpo.description

Line 242: cp_admission_cat IGS_AD_CT_HECS_PAYOP.admission_cat%TYPE) IS

238: -- The default value must not be closed.
239: DECLARE
240: v_hecs_payment_option IGS_AD_CT_HECS_PAYOP.hecs_payment_option%TYPE;
241: CURSOR c_achpo (
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

Line 245: FROM IGS_AD_CT_HECS_PAYOP achpo,

241: CURSOR c_achpo (
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(*)

Line 250: 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
251: WHERE achpo.admission_cat = cp_admission_cat) AND
252: hpo.hecs_payment_option = achpo.hecs_payment_option AND
253: hpo.closed_ind = 'N';
254: BEGIN