APPS.IGF_AW_LI_IMPORT dependencies on IGF_DB_DISB_HOLDS_ALL

Line 1094: FROM igf_db_disb_holds_all

1090: WHERE award_id = p_award_id;
1091:
1092: CURSOR c_get_disb_holds_row IS
1093: SELECT ROWID row_id
1094: FROM igf_db_disb_holds_all
1095: WHERE award_id = p_award_id;
1096:
1097: CURSOR c_get_auth_row (cp_auth_id igf_se_auth.auth_id%TYPE) IS
1098: SELECT ROWID row_id

Line 3159: x_release_flag igf_db_disb_holds_all.release_flag%TYPE;

3155: AND person_number = li_awd_disb_rec.person_number
3156: AND award_number_txt = li_awd_disb_rec.award_number_txt
3157: AND disbursement_num = li_awd_disb_rec.disbursement_num;
3158:
3159: x_release_flag igf_db_disb_holds_all.release_flag%TYPE;
3160: l_rowid VARCHAR2(25);
3161: l_hold_id igf_db_disb_holds_All.hold_id%TYPE;
3162: l_release_flag igf_db_disb_holds_all.release_flag%TYPE;
3163:

Line 3161: l_hold_id igf_db_disb_holds_All.hold_id%TYPE;

3157: AND disbursement_num = li_awd_disb_rec.disbursement_num;
3158:
3159: x_release_flag igf_db_disb_holds_all.release_flag%TYPE;
3160: l_rowid VARCHAR2(25);
3161: l_hold_id igf_db_disb_holds_All.hold_id%TYPE;
3162: l_release_flag igf_db_disb_holds_all.release_flag%TYPE;
3163:
3164: l_padding_string VARCHAR2(100);
3165:

Line 3162: l_release_flag igf_db_disb_holds_all.release_flag%TYPE;

3158:
3159: x_release_flag igf_db_disb_holds_all.release_flag%TYPE;
3160: l_rowid VARCHAR2(25);
3161: l_hold_id igf_db_disb_holds_All.hold_id%TYPE;
3162: l_release_flag igf_db_disb_holds_all.release_flag%TYPE;
3163:
3164: l_padding_string VARCHAR2(100);
3165:
3166: BEGIN