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 503: FROM hz_party_sites

499: THEN
500: BEGIN
501: SELECT party_id
502: INTO l_Charges_Rec.bill_to_party_id
503: FROM hz_party_sites
504: WHERE party_site_id = l_Charges_Rec.invoice_to_org_id;
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN
507: debug('No Bill to Party Id', l_mod_name, 1);

Line 527: FROM hz_party_sites

523: THEN
524: BEGIN
525: SELECT party_id
526: INTO l_Charges_Rec.ship_to_party_id
527: FROM hz_party_sites
528: WHERE party_site_id = l_Charges_Rec.ship_to_org_id;
529: EXCEPTION
530: WHEN NO_DATA_FOUND THEN
531: debug('No Ship to Party Id', l_mod_name, 1);

Line 2456: from hz_party_sites_v hp,

2452: CURSOR c_sr_primary_account_address(p_incident_id NUMBER, p_site_use_type VARCHAR2)
2453: IS
2454: select distinct
2455: hp.party_site_id
2456: from hz_party_sites_v hp,
2457: hz_parties hz,
2458: hz_cust_acct_sites_all hca,
2459: hz_cust_site_uses_all hcsu,
2460: cs_incidents_all_b cs