APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_AW_AWARD

Line 1101: FROM igf_aw_award

1097: -- Get the details of
1098: CURSOR c_accepted_amt(p_award_id NUMBER)
1099: IS
1100: SELECT accepted_amt
1101: FROM igf_aw_award
1102: WHERE award_id = p_award_id;
1103:
1104: l_accepted_amt c_accepted_amt%ROWTYPE;
1105:

Line 1920: FROM igf_aw_award_all

1916:
1917: CURSOR c_award_amt IS
1918: SELECT offered_amt,
1919: accepted_amt
1920: FROM igf_aw_award_all
1921: WHERE award_id = p_award_id;
1922:
1923: l_award_amt c_award_amt%ROWTYPE;
1924:

Line 1935: igf_aw_award awd,

1931: lor.p_person_id,
1932: fabase.person_id student_id
1933: FROM igf_sl_loans loans,
1934: igf_sl_lor lor,
1935: igf_aw_award awd,
1936: igf_ap_fa_base_rec fabase
1937: WHERE fabase.base_id = awd.base_id
1938: AND loans.award_id = awd.award_id
1939: AND loans.loan_id = lor.loan_id

Line 2357: FROM igf_aw_award_all

2353: */
2354: CURSOR c_award_amt IS
2355: SELECT offered_amt,
2356: accepted_amt
2357: FROM igf_aw_award_all
2358: WHERE award_id = p_award_id;
2359:
2360: l_award_amt c_award_amt%ROWTYPE;
2361:

Line 2372: igf_aw_award awd,

2368: lor.p_person_id,
2369: fabase.person_id student_id
2370: FROM igf_sl_loans loans,
2371: igf_sl_lor lor,
2372: igf_aw_award awd,
2373: igf_ap_fa_base_rec fabase
2374: WHERE fabase.base_id = awd.base_id
2375: AND loans.award_id = awd.award_id
2376: AND loans.loan_id = lor.loan_id

Line 3001: l_award_id igf_aw_award_all.award_id%TYPE,

2997:
2998: END delete_context_records;
2999:
3000: PROCEDURE insert_context_records(l_interface c_interface%ROWTYPE,
3001: l_award_id igf_aw_award_all.award_id%TYPE,
3002: l_base_id NUMBER,
3003: l_loan_num igf_sl_loans_all.loan_number%TYPE)
3004: AS
3005: /*

Line 3071: p_award_id igf_aw_award_all.award_id%TYPE

3067:
3068: END insert_context_records;
3069:
3070: PROCEDURE insert_context_disb_records( p_disb_interface c_disb_interface%ROWTYPE,
3071: p_award_id igf_aw_award_all.award_id%TYPE
3072: )
3073: AS
3074: /*
3075: || Created By : rasahoo

Line 3134: l_award_id igf_aw_award_all.award_id%TYPE;

3130: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
3131: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
3132: l_valid_for_dml VARCHAR2(2);
3133: l_error_flag BOOLEAN := FALSE;
3134: l_award_id igf_aw_award_all.award_id%TYPE;
3135: p_status BOOLEAN;
3136: l_disb_interface c_disb_interface%ROWTYPE;
3137: l_chg_interface c_chg_interface%ROWTYPE;
3138: p_d_status BOOLEAN;

Line 3188: FROM igf_aw_award_all awd

3184: cp_award_number VARCHAR2)
3185: IS
3186:
3187: SELECT awd.award_id,awd.award_status
3188: FROM igf_aw_award_all awd
3189: WHERE awd.base_id = cp_base_id
3190: AND awd.award_number_txt = cp_award_number;
3191:
3192: l_award_ref c_award_ref%ROWTYPE;

Line 3211: igf_aw_award aw,

3207: SELECT
3208: fc.fed_fund_code,
3209: fc.sys_fund_type
3210: FROM
3211: igf_aw_award aw,
3212: igf_aw_fund_mast fm,
3213: igf_aw_fund_cat fc
3214: WHERE
3215: aw.award_id = cp_award_id and