APPS.CUG_WF_EMAIL_UTIL dependencies on HZ_LOCATIONS

Line 82: -- address details from HZ_LOCATIONS table for the given Service Request, set

78: return;
79: END IF;
80:
81: -- Call the Get_Incident_Addr_Details procedure. This call, after getting the
82: -- address details from HZ_LOCATIONS table for the given Service Request, set
83: -- the item attribute 'CUG_INC_ADDR' in the workflow.
84:
85:
86:

Line 249: -- Address is from hz_locations is location type is

245: -- Date Name Desc
246: -- ---------- --------- -------------------------------------------
247: -- 05/18/04 RMANABAT Fix for bug 3630834. Modified cursor
248: -- l_Incident_Addr_csr. Added cursor l_hz_party_site_csr.
249: -- Address is from hz_locations is location type is
250: -- HZ_LOCATION, if HZ_PARTY_SITE then location_id is
251: -- derived from hz_party_sites.
252: ----------------------------------------------------------------------
253:

Line 290: FROM hz_locations l

286: l.state,
287: l.province,
288: l.postal_code,
289: l.country
290: FROM hz_locations l
291: WHERE l.location_id = l_location_id;
292: l_Incident_Addr_rec l_Incident_Addr_csr%rowtype;
293:
294: cursor l_SR_Addr_csr is

Line 325: -- Process to get the Incident Address information from HZ_LOCATIONS table for the given

321: lv_itemtype := ITEMTYPE;
322: lv_itemkey := ITEMKEY;
323: lv_incident_number := INCIDENT_NUMBER;
324:
325: -- Process to get the Incident Address information from HZ_LOCATIONS table for the given
326: -- Service Request Id. and store it in some local variable v_incident_address
327:
328: -- Begin of changes by ANEEMUCH 12-May-2002
329: -- Changed because of GSCC error, to remove CHR(10) and replace with CHR(0)

Line 335: FROM HZ_LOCATIONS hl,

331: SELECT hl.address1 || CHR(10) || hl.address2 || CHR(10) || hl.city || CHR(10) ||
332: hl.state || CHR(10) || hl.province || CHR(10) || hl.postal_code || CHR(10) ||
333: hl.country
334: INTO lv_incident_address
335: FROM HZ_LOCATIONS hl,
336: CS_INCIDENTS_ALL_b cia
337: WHERE hl.location_id = cia.install_site_use_id
338: AND cia.incident_number = lv_incident_number;
339: */

Line 346: FROM HZ_LOCATIONS hl,

342: -- Incident Address capture done in SR Tab
343: /*
344: SELECT hl.address1, hl.address2, hl.city, hl.state, hl.province, hl.postal_code, hl.country
345: INTO l_address1, l_address2, l_city, l_state, l_province, l_postal_code, l_country
346: FROM HZ_LOCATIONS hl,
347: CS_INCIDENTS_ALL_b cia
348: WHERE hl.location_id = cia.install_site_use_id
349: AND cia.incident_number = lv_incident_number;
350: