eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CUG_WF_EMAIL_UTIL dependencies on HZ_PARTY_SITES

Line 251: -- derived from hz_party_sites.

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:
254: PROCEDURE Get_Incident_Addr_Details
255: (

Line 304: FROM hz_party_sites ps

300: l_SR_Addr_rec l_SR_Addr_csr%rowtype;
301:
302: CURSOR l_hz_party_site_csr(l_party_site_id IN NUMBER) IS
303: SELECT ps.location_id
304: FROM hz_party_sites ps
305: WHERE ps.party_site_id = l_party_site_id;
306: lv_location_id NUMBER;
307:
308: