APPS.IGF_SP_AWARD dependencies on IGF_SP_STD_PRG

Line 499: CURSOR c_std_prg (cp_fee_cls_id igf_sp_std_prg.fee_cls_id%TYPE)

495: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id
496: AND fee_cls_id = NVL(cp_fee_cls_id,fee_cls_id);
497:
498: -- cursor to get the charge at program level
499: CURSOR c_std_prg (cp_fee_cls_id igf_sp_std_prg.fee_cls_id%TYPE)
500: IS
501: SELECT *
502: FROM igf_sp_std_prg
503: WHERE fee_cls_id = cp_fee_cls_id;

Line 502: FROM igf_sp_std_prg

498: -- cursor to get the charge at program level
499: CURSOR c_std_prg (cp_fee_cls_id igf_sp_std_prg.fee_cls_id%TYPE)
500: IS
501: SELECT *
502: FROM igf_sp_std_prg
503: WHERE fee_cls_id = cp_fee_cls_id;
504:
505: -- cursor to get the charge at unit level
506: CURSOR c_std_unit (cp_fee_cls_prg_id igf_sp_std_unit.fee_cls_prg_id%TYPE)