APPS.IBY_PAYMENTCARD_PKG dependencies on HZ_PARTY_SITES

Line 10: (p_party_site_id IN hz_party_sites.party_site_id%TYPE,

6: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_PAYMENTCARD_PKG';
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

Line 16: l_site_id hz_party_sites.party_site_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;
16: l_site_id hz_party_sites.party_site_id%TYPE;
17: l_site_use_rec HZ_PARTY_SITE_V2PUB.Party_Site_Use_rec_type;
18: lx_return_status VARCHAR2(1);
19: lx_msg_count NUMBER;
20: lx_msg_data VARCHAR2(2000);

Line 23: (ci_party_site IN hz_party_sites.party_site_id%TYPE,

19: lx_msg_count NUMBER;
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

Line 28: FROM hz_party_site_uses u, hz_party_sites s

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
29: WHERE (u.party_site_id = ci_party_site)
30: -- because of complexities in the payer model
31: -- do not require the site address to be owned by the card owner
32: --AND (s.party_id = NVL(ci_party_id,party_id))

Line 39: (ci_party_site hz_party_sites.party_site_id%TYPE,

35: AND ( NVL(u.begin_date,SYSDATE-10) < SYSDATE)
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

Line 44: FROM hz_party_sites

40: ci_party_id IN hz_parties.party_id%TYPE
41: )
42: IS
43: SELECT party_site_id
44: FROM hz_party_sites
45: WHERE (party_site_id = ci_party_site)
46: -- because of complexities in the payer model
47: -- do not require the site address to be owned by the card owner
48: --AND (party_id = NVL(ci_party_id,party_id))

Line 992: FROM iby_paymentcard c, hz_party_site_uses su, hz_party_sites s,

988: c.card_number, c.masked_card_number, c.expirydate, c.instrument_type,
989: c.card_issuer_code, c.finame,
990: c.single_use_flag, c.information_only_flag, c.card_purpose,
991: c.description, c.active_flag, c.inactive_date
992: FROM iby_paymentcard c, hz_party_site_uses su, hz_party_sites s,
993: hz_locations l
994: WHERE (instrid = ci_instr_id)
995: AND (c.addressid = su.party_site_use_id(+))
996: AND (su.party_site_id = s.party_site_id(+))