APPS.IGS_FI_UPG_RETENTION dependencies on IGS_FI_CREDITS_ALL

Line 45: FUNCTION get_credit_class( p_n_credit_id igs_fi_credits_all.credit_id%TYPE ) RETURN VARCHAR2 IS

41: RETURN FALSE;
42:
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

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 48: CURSOR c_crd_class (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS

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
52: ct.credit_type_id=crd.credit_type_id;

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:

Line 66: FUNCTION get_credit_number( p_n_credit_id igs_fi_credits_all.credit_id%TYPE ) RETURN VARCHAR2 IS

62: RETURN rec_crd_class.credit_class_code;
63:
64: END get_credit_class;
65:
66: FUNCTION get_credit_number( p_n_credit_id igs_fi_credits_all.credit_id%TYPE ) RETURN VARCHAR2 IS
67:
68: CURSOR c_crd_number (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
69: SELECT credit_number
70: FROM igs_fi_credits_all

Line 68: CURSOR c_crd_number (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS

64: END get_credit_class;
65:
66: FUNCTION get_credit_number( p_n_credit_id igs_fi_credits_all.credit_id%TYPE ) RETURN VARCHAR2 IS
67:
68: CURSOR c_crd_number (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
69: SELECT credit_number
70: FROM igs_fi_credits_all
71: WHERE credit_id = cp_n_credit_id;
72: rec_crd_number c_crd_number%ROWTYPE;

Line 70: FROM igs_fi_credits_all

66: FUNCTION get_credit_number( p_n_credit_id igs_fi_credits_all.credit_id%TYPE ) RETURN VARCHAR2 IS
67:
68: CURSOR c_crd_number (cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
69: SELECT credit_number
70: FROM igs_fi_credits_all
71: WHERE credit_id = cp_n_credit_id;
72: rec_crd_number c_crd_number%ROWTYPE;
73:
74: BEGIN

Line 182: CURSOR c_cr_act_details ( cp_n_credit_id igs_fi_credits_all.credit_id%TYPE ) IS

178: SELECT ROWID, app.*
179: FROM igs_fi_applications app
180: WHERE invoice_id = cp_n_invoice_id;
181:
182: CURSOR c_cr_act_details ( cp_n_credit_id igs_fi_credits_all.credit_id%TYPE ) IS
183: SELECT ROWID, crd.*
184: FROM igs_fi_cr_activities crd
185: WHERE credit_id = cp_n_credit_id;
186: rec_cr_act_details c_cr_act_details%ROWTYPE;