APPS.IBY_CREDITCARD_PKG dependencies on HZ_PARTY_SITES

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

66: RETURN 'N';
67: END isNumber;
68:
69: FUNCTION Get_Billing_Site
70: (p_party_site_id IN hz_party_sites.party_site_id%TYPE,
71: p_party_id IN hz_parties.party_id%TYPE
72: )
73: RETURN hz_party_site_uses.party_site_use_id%TYPE
74: IS

Line 76: l_site_id hz_party_sites.party_site_id%TYPE;

72: )
73: RETURN hz_party_site_uses.party_site_use_id%TYPE
74: IS
75: l_site_use_id hz_party_site_uses.party_site_use_id%TYPE;
76: l_site_id hz_party_sites.party_site_id%TYPE;
77: l_site_use_rec HZ_PARTY_SITE_V2PUB.Party_Site_Use_rec_type;
78: lx_return_status VARCHAR2(1);
79: lx_msg_count NUMBER;
80: lx_msg_data VARCHAR2(2000);

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

79: lx_msg_count NUMBER;
80: lx_msg_data VARCHAR2(2000);
81:
82: CURSOR c_site_use
83: (ci_party_site IN hz_party_sites.party_site_id%TYPE,
84: ci_party_id IN hz_parties.party_id%TYPE
85: )
86: IS
87: SELECT u.party_site_use_id

Line 88: FROM hz_party_site_uses u, hz_party_sites s

84: ci_party_id IN hz_parties.party_id%TYPE
85: )
86: IS
87: SELECT u.party_site_use_id
88: FROM hz_party_site_uses u, hz_party_sites s
89: WHERE (u.party_site_id = ci_party_site)
90: -- because of complexities in the payer model
91: -- do not require the site address to be owned by the card owner
92: --AND (s.party_id = NVL(ci_party_id,party_id))

Line 99: (ci_party_site hz_party_sites.party_site_id%TYPE,

95: AND ( NVL(u.begin_date,SYSDATE-10) < SYSDATE)
96: AND ( NVL(u.end_date,SYSDATE+10) > SYSDATE);
97:
98: CURSOR c_site
99: (ci_party_site hz_party_sites.party_site_id%TYPE,
100: ci_party_id IN hz_parties.party_id%TYPE
101: )
102: IS
103: SELECT party_site_id

Line 104: FROM hz_party_sites

100: ci_party_id IN hz_parties.party_id%TYPE
101: )
102: IS
103: SELECT party_site_id
104: FROM hz_party_sites
105: WHERE (party_site_id = ci_party_site)
106: -- because of complexities in the payer model
107: -- do not require the site address to be owned by the card owner
108: --AND (party_id = NVL(ci_party_id,party_id))

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

1797: c.single_use_flag, c.information_only_flag, c.card_purpose,
1798: c.description, c.active_flag, c.inactive_date,
1799: c.encrypted, c.expiry_sec_segment_id,
1800: c.chname_sec_segment_id
1801: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1802: hz_locations l
1803: WHERE (instrid = ci_instr_id)
1804: AND (c.addressid = su.party_site_use_id(+))
1805: AND (su.party_site_id = s.party_site_id(+))

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

1926: c.single_use_flag, c.information_only_flag, c.card_purpose,
1927: c.description, c.active_flag, c.inactive_date,
1928: c.encrypted, c.expiry_sec_segment_id,
1929: c.chname_sec_segment_id , l.province
1930: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1931: hz_locations l
1932: WHERE (instrid = ci_instr_id)
1933: AND (c.addressid = su.party_site_use_id(+))
1934: AND (su.party_site_id = s.party_site_id(+))