APPS.IGS_FI_CC_PMT dependencies on IGS_FI_CREDITS_ALL

Line 8: FROM igs_fi_credits_all fc

4: CURSOR c_credits(cp_cc IN VARCHAR2,
5: cp_pending IN VARCHAR2)
6: IS
7: SELECT fc.rowid, fc.*
8: FROM igs_fi_credits_all fc
9: WHERE credit_instrument = cp_cc
10: AND credit_card_status_code = cp_pending
11: AND credit_card_tangible_cd IS NOT NULL
12: FOR UPDATE NOWAIT;

Line 66: l_c_cc_status igs_fi_credits_all.credit_card_status_code%TYPE := 'PENDING';

62:
63: e_skip EXCEPTION;
64:
65: l_n_status iby_trans_all_v.status%TYPE;
66: l_c_cc_status igs_fi_credits_all.credit_card_status_code%TYPE := 'PENDING';
67: l_c_tangible_cd igs_fi_credits_all.credit_card_tangible_cd%TYPE;
68: l_c_payee_cd igs_fi_credits_all.credit_card_payee_cd%TYPE;
69: l_flag BOOLEAN := FALSE;
70: l_c_pnum hz_parties.party_number%TYPE;

Line 67: l_c_tangible_cd igs_fi_credits_all.credit_card_tangible_cd%TYPE;

63: e_skip EXCEPTION;
64:
65: l_n_status iby_trans_all_v.status%TYPE;
66: l_c_cc_status igs_fi_credits_all.credit_card_status_code%TYPE := 'PENDING';
67: l_c_tangible_cd igs_fi_credits_all.credit_card_tangible_cd%TYPE;
68: l_c_payee_cd igs_fi_credits_all.credit_card_payee_cd%TYPE;
69: l_flag BOOLEAN := FALSE;
70: l_c_pnum hz_parties.party_number%TYPE;
71: l_b_exception_flag BOOLEAN := FALSE;

Line 68: l_c_payee_cd igs_fi_credits_all.credit_card_payee_cd%TYPE;

64:
65: l_n_status iby_trans_all_v.status%TYPE;
66: l_c_cc_status igs_fi_credits_all.credit_card_status_code%TYPE := 'PENDING';
67: l_c_tangible_cd igs_fi_credits_all.credit_card_tangible_cd%TYPE;
68: l_c_payee_cd igs_fi_credits_all.credit_card_payee_cd%TYPE;
69: l_flag BOOLEAN := FALSE;
70: l_c_pnum hz_parties.party_number%TYPE;
71: l_b_exception_flag BOOLEAN := FALSE;
72: