APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_FUND_FEECLAS_ALL

Line 212: p_fee_class OUT NOCOPY igf_aw_fund_feeclas_all.fee_class%TYPE

208:
209: --Create pay feeclass for the target award year
210: FUNCTION create_pay_feeclass(p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
211: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
212: p_fee_class OUT NOCOPY igf_aw_fund_feeclas_all.fee_class%TYPE
213: )
214: RETURN BOOLEAN IS
215: --------------------------------------------------------------------------------
216: -- Created by : ridas, Oracle India

Line 228: FROM igf_aw_fund_feeclas_all fcls

224: -- Get the details of the feeclasses for a given Fund ID
225: CURSOR c_get_feeclass ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
226: ) IS
227: SELECT fcls.fclass_id, fcls.fee_class
228: FROM igf_aw_fund_feeclas_all fcls
229: WHERE fund_id = cp_ref_fund_id;
230:
231: l_rowid VARCHAR2(25);
232: l_fclass_id igf_aw_fund_feeclas_all.fclass_id%TYPE;

Line 232: l_fclass_id igf_aw_fund_feeclas_all.fclass_id%TYPE;

228: FROM igf_aw_fund_feeclas_all fcls
229: WHERE fund_id = cp_ref_fund_id;
230:
231: l_rowid VARCHAR2(25);
232: l_fclass_id igf_aw_fund_feeclas_all.fclass_id%TYPE;
233:
234: BEGIN
235: FOR l_get_feeclass IN c_get_feeclass( p_ref_fund_id ) LOOP
236: l_rowid := NULL;

Line 772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;

768: l_new_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;
769: E_SKIP_FUND EXCEPTION;
770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;
771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;
773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;
774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
775: l_exclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
776: l_discontinued_flg VARCHAR2(1) := 'N';