APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_LB_CR_TYPES

Line 2406: CURSOR cur_lb_crt_map(cp_lockbox_name igs_fi_lb_cr_types.lockbox_name%TYPE,

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,
2407: cp_bank_cd igs_fi_lb_cr_types.bank_cd%TYPE) IS
2408: SELECT credit_type_id
2409: FROM igs_fi_lb_cr_types
2410: WHERE bank_cd = cp_bank_cd

Line 2407: cp_bank_cd igs_fi_lb_cr_types.bank_cd%TYPE) IS

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,
2407: cp_bank_cd igs_fi_lb_cr_types.bank_cd%TYPE) IS
2408: SELECT credit_type_id
2409: FROM igs_fi_lb_cr_types
2410: WHERE bank_cd = cp_bank_cd
2411: AND lockbox_name = cp_lockbox_name;

Line 2409: FROM igs_fi_lb_cr_types

2405:
2406: CURSOR cur_lb_crt_map(cp_lockbox_name igs_fi_lb_cr_types.lockbox_name%TYPE,
2407: cp_bank_cd igs_fi_lb_cr_types.bank_cd%TYPE) IS
2408: SELECT credit_type_id
2409: FROM igs_fi_lb_cr_types
2410: WHERE bank_cd = cp_bank_cd
2411: AND lockbox_name = cp_lockbox_name;
2412:
2413: l_t_rc_tab lb_receipt_tab;