APPS.IGF_AW_PACKAGING dependencies on IGF_GR_RFMS_DISB_ALL

Line 1443: igf_gr_rfms_disb_all disb

1439: cp_award_id igf_aw_award_all.award_id%TYPE
1440: ) IS
1441: SELECT SUM(disb.disb_amt)
1442: FROM igf_gr_rfms_all rfms,
1443: igf_gr_rfms_disb_all disb
1444: WHERE rfms.award_id = cp_award_id
1445: AND rfms.origination_id = disb.origination_id
1446: AND disb.disb_ack_act_status IN ('S','A','D','C');
1447:

Line 2347: igf_gr_rfms_disb_all rfmd

2343: ) IS
2344: SELECT rfmd.ROWID row_id,
2345: rfmd.*
2346: FROM igf_gr_rfms_all rfms,
2347: igf_gr_rfms_disb_all rfmd
2348: WHERE rfms.origination_id = rfmd.origination_id
2349: AND rfms.award_id = cp_award_id
2350: AND rfmd.disb_ref_num = cp_disb_num;
2351: l_pell_disb_orig c_pell_disb_orig%ROWTYPE;

Line 2354: lv_rfmd_id igf_gr_rfms_disb_all.rfmd_id%TYPE;

2350: AND rfmd.disb_ref_num = cp_disb_num;
2351: l_pell_disb_orig c_pell_disb_orig%ROWTYPE;
2352:
2353: lv_row_id VARCHAR2(25);
2354: lv_rfmd_id igf_gr_rfms_disb_all.rfmd_id%TYPE;
2355: l_orig_id igf_gr_rfms_all.origination_id%TYPE;
2356:
2357: -- Get origination id for a PELL award
2358: CURSOR c_orig_id(

Line 4971: FROM igf_gr_rfms_disb_all disb,

4967: CURSOR c_pell_disb_orig_stat(
4968: cp_award_id igf_aw_award_all.award_id%TYPE
4969: ) IS
4970: SELECT disb.disb_ack_act_status
4971: FROM igf_gr_rfms_disb_all disb,
4972: igf_gr_rfms_all rfms
4973: WHERE rfms.origination_id = disb.origination_id
4974: AND rfms.award_id = cp_award_id
4975: AND disb.disb_ack_act_status = 'S'

Line 4977: l_pell_disb_orig_stat igf_gr_rfms_disb_all.disb_ack_act_status%TYPE;

4973: WHERE rfms.origination_id = disb.origination_id
4974: AND rfms.award_id = cp_award_id
4975: AND disb.disb_ack_act_status = 'S'
4976: AND ROWNUM = 1;
4977: l_pell_disb_orig_stat igf_gr_rfms_disb_all.disb_ack_act_status%TYPE;
4978:
4979: lv_rowid VARCHAR2(25);
4980: l_sl_number NUMBER(15);
4981: