DBA Data[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on IGS_FI_INV_INT

Line 2576: FROM igs_fi_inv_int

2572:
2573:
2574: CURSOR cur_sf_invoice_num(p_invoice_num igf_aw_li_dact_ints.sf_invoice_num_txt%TYPE) IS
2575: SELECT invoice_number, invoice_amount, invoice_id
2576: FROM igs_fi_inv_int
2577: WHERE person_id = g_person_id
2578: AND invoice_number = p_invoice_num;
2579: cur_sf_invoice_num_rec cur_sf_invoice_num%ROWTYPE;
2580: l_trans_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

Line 2580: l_trans_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

2576: FROM igs_fi_inv_int
2577: WHERE person_id = g_person_id
2578: AND invoice_number = p_invoice_num;
2579: cur_sf_invoice_num_rec cur_sf_invoice_num%ROWTYPE;
2580: l_trans_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
2581: l_trans_spnsr_charge_id igs_fi_inv_int_all.invoice_id%TYPE;
2582:
2583: --l_disbact_rec igf_aw_li_dact_ints%ROWTYPE;
2584: l_disbact_rec cur_li_disb_act_int%ROWTYPE;

Line 2581: l_trans_spnsr_charge_id igs_fi_inv_int_all.invoice_id%TYPE;

2577: WHERE person_id = g_person_id
2578: AND invoice_number = p_invoice_num;
2579: cur_sf_invoice_num_rec cur_sf_invoice_num%ROWTYPE;
2580: l_trans_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
2581: l_trans_spnsr_charge_id igs_fi_inv_int_all.invoice_id%TYPE;
2582:
2583: --l_disbact_rec igf_aw_li_dact_ints%ROWTYPE;
2584: l_disbact_rec cur_li_disb_act_int%ROWTYPE;
2585: l_ctr PLS_INTEGER;