APPS.IBY_PAYMENTCARD_PKG dependencies on HZ_PARTIES

Line 11: p_party_id IN hz_parties.party_id%TYPE

7:
8:
9: FUNCTION Get_Billing_Site
10: (p_party_site_id IN hz_party_sites.party_site_id%TYPE,
11: p_party_id IN hz_parties.party_id%TYPE
12: )
13: RETURN hz_party_site_uses.party_site_use_id%TYPE
14: IS
15: l_site_use_id hz_party_site_uses.party_site_use_id%TYPE;

Line 24: ci_party_id IN hz_parties.party_id%TYPE

20: lx_msg_data VARCHAR2(2000);
21:
22: CURSOR c_site_use
23: (ci_party_site IN hz_party_sites.party_site_id%TYPE,
24: ci_party_id IN hz_parties.party_id%TYPE
25: )
26: IS
27: SELECT u.party_site_use_id
28: FROM hz_party_site_uses u, hz_party_sites s

Line 40: ci_party_id IN hz_parties.party_id%TYPE

36: AND ( NVL(u.end_date,SYSDATE+10) > SYSDATE);
37:
38: CURSOR c_site
39: (ci_party_site hz_party_sites.party_site_id%TYPE,
40: ci_party_id IN hz_parties.party_id%TYPE
41: )
42: IS
43: SELECT party_site_id
44: FROM hz_party_sites

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

276: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;
277:
278:
279: CURSOR c_card
280: (ci_owner_id IN hz_parties.party_id%TYPE,
281: ci_card_number IN iby_paymentcard.card_number%TYPE
282: )
283: IS
284: SELECT instrid