APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_AW_AWARD_ALL

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 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 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;