APPS.IGS_FI_UPG_RETENTION dependencies on IGS_FI_CR_TYPES

Line 47: -- bug 5018036 : joined IGS_FI_CREDITS_ALL , IGS_FI_CR_TYPES instead using IGS_FI_CREDITS_V

43: END find_invoice;
44:
45: FUNCTION get_credit_class( p_n_credit_id igs_fi_credits_all.credit_id%TYPE ) RETURN VARCHAR2 IS
46:
47: -- bug 5018036 : joined IGS_FI_CREDITS_ALL , IGS_FI_CR_TYPES instead using IGS_FI_CREDITS_V
48: CURSOR c_crd_class (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
49: SELECT credit_class credit_class_code
50: FROM igs_fi_credits_all crd, igs_fi_cr_types ct
51: WHERE crd.credit_id = cp_n_credit_id AND

Line 50: FROM igs_fi_credits_all crd, igs_fi_cr_types ct

46:
47: -- bug 5018036 : joined IGS_FI_CREDITS_ALL , IGS_FI_CR_TYPES instead using IGS_FI_CREDITS_V
48: CURSOR c_crd_class (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
49: SELECT credit_class credit_class_code
50: FROM igs_fi_credits_all crd, igs_fi_cr_types ct
51: WHERE crd.credit_id = cp_n_credit_id AND
52: ct.credit_type_id=crd.credit_type_id;
53: rec_crd_class c_crd_class%ROWTYPE;
54: