DBA Data[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on IGF_AW_AWD_DISB_ALL

Line 1084: FROM igf_aw_awd_disb_all

1080: c_award_hist_rec c_get_awd_hist_details%ROWTYPE;
1081:
1082: CURSOR c_get_disb_row IS
1083: SELECT ROWID row_id, auth_id
1084: FROM igf_aw_awd_disb_all
1085: WHERE award_id = p_award_id;
1086:
1087: CURSOR c_get_disb_dtl_row IS
1088: SELECT ROWID row_id

Line 1156: -- while deleting the record in IGF_AW_AWD_DISB_ALL delete also from IGF_AW_DB_CHG_DTLS

1152: END LOOP;
1153: CLOSE c_get_awd_hist_details;
1154: -- bvisvana - Bug # 4635941 - END
1155:
1156: -- while deleting the record in IGF_AW_AWD_DISB_ALL delete also from IGF_AW_DB_CHG_DTLS
1157:
1158: FOR c_get_disb_dtl_row_rec IN c_get_disb_dtl_row LOOP
1159: igf_db_awd_disb_dtl_pkg.delete_row(c_get_disb_dtl_row_rec.row_id);
1160: END LOOP;

Line 1785: l_net_amount igf_aw_awd_disb_all.disb_net_amt%TYPE;

1781: l_var_seq_number igs_ca_inst.sequence_number%TYPE;
1782: l_return_status_dh VARCHAR2(1);
1783: l_return_status_da VARCHAR2(1);
1784: l_disb_rec_ins_status VARCHAR2(1);
1785: l_net_amount igf_aw_awd_disb_all.disb_net_amt%TYPE;
1786:
1787: l_padding_string VARCHAR2(100);
1788:
1789: PROCEDURE create_disbursment_record(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,

Line 1816: FROM igf_aw_awd_disb_all disb

1812: WHERE alternate_code = p_alternate_code;
1813:
1814: CURSOR cur_awd_disb( cp_row_id ROWID) IS
1815: SELECT rowid row_id, disb.*
1816: FROM igf_aw_awd_disb_all disb
1817: WHERE rowid = cp_row_id;
1818:
1819: CURSOR c_get_fed_fund (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE) IS
1820: SELECT fed_fund_code