DBA Data[Home] [Help]

APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_LB_FCIS

Line 2399: cp_bank_cd igs_fi_lb_fcis.bank_cd%TYPE) IS

2395: FROM igs_fi_lockboxes
2396: WHERE lockbox_name = cp_lockbox_name;
2397:
2398: CURSOR cur_fcmap(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
2399: cp_bank_cd igs_fi_lb_fcis.bank_cd%TYPE) IS
2400: SELECT fee_cal_type,
2401: fee_ci_sequence_number
2402: FROM igs_fi_lb_fcis
2403: WHERE lockbox_name = cp_lockbox_name

Line 2402: FROM igs_fi_lb_fcis

2398: CURSOR cur_fcmap(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
2399: cp_bank_cd igs_fi_lb_fcis.bank_cd%TYPE) IS
2400: SELECT fee_cal_type,
2401: fee_ci_sequence_number
2402: FROM igs_fi_lb_fcis
2403: WHERE lockbox_name = cp_lockbox_name
2404: AND bank_cd = cp_bank_cd;
2405:
2406: CURSOR cur_lb_crt_map(cp_lockbox_name igs_fi_lb_cr_types.lockbox_name%TYPE,