APPS.IEM_EMAIL_PROC_PVT dependencies on HZ_PARTY_SITES

Line 7486: from hz_party_sites

7482:
7483: ELSIF p_incident_site_number is not null then
7484: BEGIN
7485: select party_id into x_customer_id
7486: from hz_party_sites
7487: where party_site_number = p_incident_site_number;
7488: EXCEPTION
7489: when TOO_MANY_ROWS then
7490: x_customer_id := null;

Line 8250: from hz_party_sites

8246:
8247: IF (g_customer_id IS NOT NULL) AND (p_incident_site_number IS NOT NULL) THEN
8248: BEGIN
8249: select party_site_id into x_incident_location_id
8250: from hz_party_sites
8251: where party_site_number = p_incident_site_number
8252: and party_id = g_customer_id;
8253: EXCEPTION
8254: when TOO_MANY_ROWS then

Line 8271: from hz_party_sites

8267: END;
8268: ELSE
8269: BEGIN
8270: select party_site_id into x_incident_location_id
8271: from hz_party_sites
8272: where party_site_number = p_incident_site_number;
8273: EXCEPTION
8274: when TOO_MANY_ROWS then
8275: x_incident_location_id := null;

Line 8942: from hz_party_sites

8938: BEGIN
8939: IF (g_customer_id IS NOT NULL) THEN
8940: BEGIN
8941: select party_site_id into x_party_site_id
8942: from hz_party_sites
8943: where upper(party_site_name) = upper(p_site_name)
8944: and party_id = g_customer_id;
8945: EXCEPTION
8946: when TOO_MANY_ROWS then

Line 9062: FROM hz_party_sites s,

9058:
9059:
9060: BEGIN
9061: SELECT s.party_site_id into x_bill_to_site_id
9062: FROM hz_party_sites s,
9063: hz_parties p,
9064: hz_locations l,
9065: hz_party_site_uses u
9066: WHERE p.party_id = p_customer_id

Line 9100: FROM hz_party_sites s,

9096: END;
9097:
9098: BEGIN
9099: SELECT s.party_site_id into x_ship_to_site_id
9100: FROM hz_party_sites s,
9101: hz_parties p,
9102: hz_locations l,
9103: hz_party_site_uses u
9104: WHERE p.party_id = p_customer_id