APPS.IGF_AW_PACKAGING dependencies on IGF_GR_RFMS_ALL

Line 1220: FROM igf_gr_rfms_all rfms

1216: cp_amount igf_aw_award_all.offered_amt%TYPE
1217: ) IS
1218: SELECT rfms.rowid row_id,
1219: rfms.*
1220: FROM igf_gr_rfms_all rfms
1221: WHERE award_id = cp_award_id
1222: AND pell_amount <> cp_amount
1223: AND orig_action_code <> 'S';
1224: l_orig_action_code igf_gr_rfms_all.orig_action_code%TYPE;

Line 1224: l_orig_action_code igf_gr_rfms_all.orig_action_code%TYPE;

1220: FROM igf_gr_rfms_all rfms
1221: WHERE award_id = cp_award_id
1222: AND pell_amount <> cp_amount
1223: AND orig_action_code <> 'S';
1224: l_orig_action_code igf_gr_rfms_all.orig_action_code%TYPE;
1225:
1226: BEGIN
1227: FOR l_pell_orig IN c_pell_orig(p_award_id,p_amount) LOOP
1228: IF l_pell_orig.orig_action_code = 'N' THEN

Line 1442: FROM igf_gr_rfms_all rfms,

1438: CURSOR c_rfms_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');

Line 2346: FROM igf_gr_rfms_all rfms,

2342: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
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;

Line 2355: l_orig_id igf_gr_rfms_all.origination_id%TYPE;

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(
2359: cp_award_id igf_aw_award_all.award_id%TYPE

Line 2362: FROM igf_gr_rfms_all rfms

2358: CURSOR c_orig_id(
2359: cp_award_id igf_aw_award_all.award_id%TYPE
2360: ) IS
2361: SELECT rfms.origination_id
2362: FROM igf_gr_rfms_all rfms
2363: WHERE rfms.award_id = cp_award_id;
2364:
2365: BEGIN
2366:

Line 4461: FROM igf_gr_rfms_all

4457:
4458: -- Get pell status
4459: CURSOR c_pell IS
4460: SELECT 'x'
4461: FROM igf_gr_rfms_all
4462: WHERE award_id = p_award_id
4463: AND orig_action_code NOT IN ('R','N','A','D','C');--ready to send and not ready to send
4464: l_pell c_pell%ROWTYPE;
4465: BEGIN

Line 4960: FROM igf_gr_rfms_all

4956: CURSOR c_pell_orig_stat(
4957: cp_award_id igf_aw_award_all.award_id%TYPE
4958: ) IS
4959: SELECT orig_action_code
4960: FROM igf_gr_rfms_all
4961: WHERE award_id = cp_award_id;
4962: l_pell_orig_stat igf_gr_rfms_all.orig_action_code%TYPE;
4963:
4964: lb_awards_locked BOOLEAN;

Line 4962: l_pell_orig_stat igf_gr_rfms_all.orig_action_code%TYPE;

4958: ) IS
4959: SELECT orig_action_code
4960: FROM igf_gr_rfms_all
4961: WHERE award_id = cp_award_id;
4962: l_pell_orig_stat igf_gr_rfms_all.orig_action_code%TYPE;
4963:
4964: lb_awards_locked BOOLEAN;
4965:
4966: -- Get pell disb orig status

Line 4972: igf_gr_rfms_all rfms

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'
4976: AND ROWNUM = 1;