APPS.IGS_FI_CC_PMT dependencies on IBY_TRANS_ALL_V

Line 46: CURSOR c_iby_trans(cp_tangible_id IN iby_trans_all_v.tangibleid%TYPE,

42: -- call to igs_ad_gen_015.update_igs_ad_app_req.
43: -------------------------------------------------------------------
44:
45: -- Get the payment status
46: CURSOR c_iby_trans(cp_tangible_id IN iby_trans_all_v.tangibleid%TYPE,
47: cp_payee_id IN iby_trans_all_v.payeeid%TYPE,
48: cp_capture IN VARCHAR2) IS
49: SELECT status
50: FROM iby_trans_all_v

Line 47: cp_payee_id IN iby_trans_all_v.payeeid%TYPE,

43: -------------------------------------------------------------------
44:
45: -- Get the payment status
46: CURSOR c_iby_trans(cp_tangible_id IN iby_trans_all_v.tangibleid%TYPE,
47: cp_payee_id IN iby_trans_all_v.payeeid%TYPE,
48: cp_capture IN VARCHAR2) IS
49: SELECT status
50: FROM iby_trans_all_v
51: WHERE tangibleid = cp_tangible_id AND

Line 50: FROM iby_trans_all_v

46: CURSOR c_iby_trans(cp_tangible_id IN iby_trans_all_v.tangibleid%TYPE,
47: cp_payee_id IN iby_trans_all_v.payeeid%TYPE,
48: cp_capture IN VARCHAR2) IS
49: SELECT status
50: FROM iby_trans_all_v
51: WHERE tangibleid = cp_tangible_id AND
52: payeeid = cp_payee_id AND
53: reqtype = cp_capture
54: ORDER BY reqdate DESC;

Line 65: l_n_status iby_trans_all_v.status%TYPE;

61: WHERE party_id = cp_person_id;
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;