APPS.IGS_FI_CC_PMT dependencies on HZ_PARTIES

Line 57: CURSOR c_pers(cp_person_id IN hz_parties.party_id%TYPE

53: reqtype = cp_capture
54: ORDER BY reqdate DESC;
55:
56: -- Get the person number of the person
57: CURSOR c_pers(cp_person_id IN hz_parties.party_id%TYPE
58: ) IS
59: SELECT party_number
60: FROM hz_parties
61: WHERE party_id = cp_person_id;

Line 60: FROM hz_parties

56: -- Get the person number of the person
57: CURSOR c_pers(cp_person_id IN hz_parties.party_id%TYPE
58: ) IS
59: SELECT party_number
60: FROM hz_parties
61: WHERE party_id = cp_person_id;
62:
63: e_skip EXCEPTION;
64:

Line 70: l_c_pnum hz_parties.party_number%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:
73: g_c_capture CONSTANT VARCHAR2(13):= 'ORAPMTCAPTURE';
74: g_c_failure CONSTANT VARCHAR2(7) := 'FAILURE';