DBA Data[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on IGS_FI_CREDITS_ALL

Line 2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;

2559: FROM igs_fi_credits
2560: WHERE party_id = g_person_id
2561: AND credit_number = p_credit_num;
2562: cur_sf_credit_num_rec cur_sf_credit_num%ROWTYPE;
2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;
2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;
2565:
2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
2567: SELECT cal_type, sequence_number

Line 2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;

2560: WHERE party_id = g_person_id
2561: AND credit_number = p_credit_num;
2562: cur_sf_credit_num_rec cur_sf_credit_num%ROWTYPE;
2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;
2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;
2565:
2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
2567: SELECT cal_type, sequence_number
2568: FROM igs_ca_inst