APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_GR_RFMS

Line 692: FROM igf_gr_rfms

688: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
689:
690: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
691: SELECT orig_action_code
692: FROM igf_gr_rfms
693: WHERE award_id = cp_award_id;
694:
695: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
696:

Line 695: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;

691: SELECT orig_action_code
692: FROM igf_gr_rfms
693: WHERE award_id = cp_award_id;
694:
695: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
696:
697: CURSOR cur_orig_status (cp_award_id NUMBER) IS
698: SELECT loan_status, loan_chg_status
699: FROM igf_sl_loans_all

Line 832: FROM igf_gr_rfms

828: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
829:
830: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
831: SELECT orig_action_code
832: FROM igf_gr_rfms
833: WHERE award_id = cp_award_id;
834:
835: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
836:

Line 835: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;

831: SELECT orig_action_code
832: FROM igf_gr_rfms
833: WHERE award_id = cp_award_id;
834:
835: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
836:
837: CURSOR cur_orig_status (cp_award_id NUMBER) IS
838: SELECT loan_status, loan_chg_status
839: FROM igf_sl_loans_all

Line 972: FROM igf_gr_rfms

968: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
969:
970: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
971: SELECT orig_action_code
972: FROM igf_gr_rfms
973: WHERE award_id = cp_award_id;
974:
975: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
976:

Line 975: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;

971: SELECT orig_action_code
972: FROM igf_gr_rfms
973: WHERE award_id = cp_award_id;
974:
975: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
976:
977: CURSOR cur_orig_status (cp_award_id NUMBER) IS
978: SELECT loan_status,loan_chg_status
979: FROM igf_sl_loans_all

Line 1434: FROM igf_gr_rfms

1430: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
1431:
1432: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
1433: SELECT orig_action_code
1434: FROM igf_gr_rfms
1435: WHERE award_id = cp_award_id;
1436:
1437: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
1438:

Line 1437: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;

1433: SELECT orig_action_code
1434: FROM igf_gr_rfms
1435: WHERE award_id = cp_award_id;
1436:
1437: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
1438:
1439: CURSOR cur_orig_status (cp_award_id NUMBER) IS
1440: SELECT loan_status, loan_chg_status
1441: FROM igf_sl_loans_all

Line 1612: FROM igf_gr_rfms

1608: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
1609:
1610: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
1611: SELECT orig_action_code
1612: FROM igf_gr_rfms
1613: WHERE award_id = cp_award_id;
1614:
1615: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
1616:

Line 1615: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;

1611: SELECT orig_action_code
1612: FROM igf_gr_rfms
1613: WHERE award_id = cp_award_id;
1614:
1615: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
1616:
1617: CURSOR cur_orig_status (cp_award_id NUMBER) IS
1618: SELECT loan_status, loan_chg_status
1619: FROM igf_sl_loans_all

Line 1791: FROM igf_gr_rfms

1787: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
1788:
1789: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
1790: SELECT orig_action_code
1791: FROM igf_gr_rfms
1792: WHERE award_id = cp_award_id;
1793:
1794: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
1795:

Line 1794: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;

1790: SELECT orig_action_code
1791: FROM igf_gr_rfms
1792: WHERE award_id = cp_award_id;
1793:
1794: l_orig_status_pell igf_gr_rfms.orig_action_code%TYPE;
1795:
1796: CURSOR cur_orig_status (cp_award_id NUMBER) IS
1797: SELECT loan_status,loan_chg_status
1798: FROM igf_sl_loans_all