APPS.CSD_PROCESS_PVT dependencies on HZ_PARTY_SITES

Line 174: FROM hz_party_sites

170: WHERE party_site_use_id = p_party_site_use_id;
171:
172: CURSOR c_party_id(p_party_site_id IN NUMBER) IS
173: SELECT party_id
174: FROM hz_party_sites
175: WHERE party_site_id = p_party_site_id;
176:
177: BEGIN
178: -- Standard Start of API savepoint

Line 475: FROM hz_party_sites

471: THEN
472: BEGIN
473: SELECT party_id
474: INTO l_Charges_Rec.bill_to_party_id
475: FROM hz_party_sites
476: WHERE party_site_id = l_Charges_Rec.invoice_to_org_id;
477: EXCEPTION
478: WHEN NO_DATA_FOUND THEN
479: debug('No Bill to Party Id', l_mod_name, 1);

Line 499: FROM hz_party_sites

495: THEN
496: BEGIN
497: SELECT party_id
498: INTO l_Charges_Rec.ship_to_party_id
499: FROM hz_party_sites
500: WHERE party_site_id = l_Charges_Rec.ship_to_org_id;
501: EXCEPTION
502: WHEN NO_DATA_FOUND THEN
503: debug('No Ship to Party Id', l_mod_name, 1);

Line 2373: from hz_party_sites_v hp,

2369: CURSOR c_sr_primary_account_address(p_incident_id NUMBER, p_site_use_type VARCHAR2)
2370: IS
2371: select distinct
2372: hp.party_site_id
2373: from hz_party_sites_v hp,
2374: hz_parties hz,
2375: hz_cust_acct_sites_all hca,
2376: hz_cust_site_uses_all hcsu,
2377: cs_incidents_all_b cs