APPS.IBY_CREDITCARD_PKG dependencies on HZ_PARTY_SITES

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

34: RETURN 'N';
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

Line 44: l_site_id hz_party_sites.party_site_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;
44: l_site_id hz_party_sites.party_site_id%TYPE;
45: l_site_use_rec HZ_PARTY_SITE_V2PUB.Party_Site_Use_rec_type;
46: lx_return_status VARCHAR2(1);
47: lx_msg_count NUMBER;
48: lx_msg_data VARCHAR2(2000);

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

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

Line 56: FROM hz_party_site_uses u, hz_party_sites s

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

Line 67: (ci_party_site hz_party_sites.party_site_id%TYPE,

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

Line 72: FROM hz_party_sites

68: ci_party_id IN hz_parties.party_id%TYPE
69: )
70: IS
71: SELECT party_site_id
72: FROM hz_party_sites
73: WHERE (party_site_id = ci_party_site)
74: -- because of complexities in the payer model
75: -- do not require the site address to be owned by the card owner
76: --AND (party_id = NVL(ci_party_id,party_id))

Line 1531: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,

1527: c.single_use_flag, c.information_only_flag, c.card_purpose,
1528: c.description, c.active_flag, c.inactive_date,
1529: c.encrypted, c.expiry_sec_segment_id,
1530: c.chname_sec_segment_id
1531: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1532: hz_locations l
1533: WHERE (instrid = ci_instr_id)
1534: AND (c.addressid = su.party_site_use_id(+))
1535: AND (su.party_site_id = s.party_site_id(+))