APPS.IGF_SP_AWARD dependencies on IGF_SP_STD_UNIT

Line 506: CURSOR c_std_unit (cp_fee_cls_prg_id igf_sp_std_unit.fee_cls_prg_id%TYPE)

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)
507: IS
508: SELECT *
509: FROM igf_sp_std_unit
510: WHERE fee_cls_prg_id = cp_fee_cls_prg_id;

Line 509: FROM igf_sp_std_unit

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)
507: IS
508: SELECT *
509: FROM igf_sp_std_unit
510: WHERE fee_cls_prg_id = cp_fee_cls_prg_id;
511: rec_std_unit c_std_unit%ROWTYPE;
512:
513: -- cursor to check forprg attempt