APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_SL_LOANS_ALL

Line 699: FROM igf_sl_loans_all

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
700: WHERE award_id = cp_award_id;
701:
702: l_orig_status cur_orig_status%ROWTYPE;
703:

Line 839: FROM igf_sl_loans_all

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
840: WHERE award_id = cp_award_id;
841:
842: l_orig_status cur_orig_status%ROWTYPE;
843:

Line 979: FROM igf_sl_loans_all

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
980: WHERE award_id = cp_award_id;
981:
982: l_orig_status cur_orig_status%ROWTYPE;
983:

Line 1441: FROM igf_sl_loans_all

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
1442: WHERE award_id = cp_award_id;
1443:
1444: l_orig_status cur_orig_status%ROWTYPE;
1445:

Line 1619: FROM igf_sl_loans_all

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
1620: WHERE award_id = cp_award_id;
1621:
1622: l_orig_status cur_orig_status%ROWTYPE;
1623:

Line 1798: FROM igf_sl_loans_all

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
1799: WHERE award_id = cp_award_id;
1800:
1801: l_orig_status cur_orig_status%ROWTYPE;
1802: