APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_FI_CR_TYPES_ALL

Line 326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

322: vvutukur 18-Jun-2003 Enh#2831582.Lockbox Build. Removed call to function validate_lockbox as the same has been removed.
323: schodava 11-Jun-03 Enh # 2831587. Credit Card Fund Transfer Build
324: Added validations for Credit Card status and credit card payee
325: ********************************************************************************************** */
326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
327: l_n_pay_cr_type_id igs_fi_cr_types.payment_credit_type_id%TYPE;
328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;
330: l_b_return_status BOOLEAN;

Line 920: CURSOR cur_cr_typ (cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE)

916: Known limitations,enhancements,remarks:
917: Change History
918: Who When What
919: ********************************************************************************************** */
920: CURSOR cur_cr_typ (cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE)
921: IS
922: SELECT credit_class
923: FROM igs_fi_cr_types_all
924: WHERE credit_type_id = cp_credit_type_id

Line 923: FROM igs_fi_cr_types_all

919: ********************************************************************************************** */
920: CURSOR cur_cr_typ (cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE)
921: IS
922: SELECT credit_class
923: FROM igs_fi_cr_types_all
924: WHERE credit_type_id = cp_credit_type_id
925: AND TRUNC(SYSDATE) BETWEEN TRUNC(effective_start_date) AND TRUNC(NVL(effective_end_date,SYSDATE));
926:
927: BEGIN