APPS.IBY_CREDITCARD_PKG dependencies on HZ_PARTIES

Line 39: p_party_id IN hz_parties.party_id%TYPE

35: END Other_CC_Attribs_Encrypted;
36:
37: FUNCTION Get_Billing_Site
38: (p_party_site_id IN hz_party_sites.party_site_id%TYPE,
39: p_party_id IN hz_parties.party_id%TYPE
40: )
41: RETURN hz_party_site_uses.party_site_use_id%TYPE
42: IS
43: l_site_use_id hz_party_site_uses.party_site_use_id%TYPE;

Line 52: ci_party_id IN hz_parties.party_id%TYPE

48: lx_msg_data VARCHAR2(2000);
49:
50: CURSOR c_site_use
51: (ci_party_site IN hz_party_sites.party_site_id%TYPE,
52: ci_party_id IN hz_parties.party_id%TYPE
53: )
54: IS
55: SELECT u.party_site_use_id
56: FROM hz_party_site_uses u, hz_party_sites s

Line 68: ci_party_id IN hz_parties.party_id%TYPE

64: AND ( NVL(u.end_date,SYSDATE+10) > SYSDATE);
65:
66: CURSOR c_site
67: (ci_party_site hz_party_sites.party_site_id%TYPE,
68: ci_party_id IN hz_parties.party_id%TYPE
69: )
70: IS
71: SELECT party_site_id
72: FROM hz_party_sites

Line 367: (ci_owner_id IN hz_parties.party_id%TYPE,

363: l_keyvalid VARCHAR2(100) := NULL;
364:
365:
366: CURSOR c_card
367: (ci_owner_id IN hz_parties.party_id%TYPE,
368: ci_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
369: ci_hash2 IN iby_creditcard.cc_number_hash1%TYPE
370: )
371: IS