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.IGS_PE_WF_GEN dependencies on HZ_LOCATIONS

Line 318: hz_locations hzl,

314: hzl.county, hzl.postal_code, hzl.country, hzl.delivery_point_code ,hzp.party_number,
315: hzp.party_name,hps.identifying_address_flag
316: FROM
317: hz_party_sites hps,
318: hz_locations hzl,
319: hz_parties hzp
320: WHERE
321: hps.party_site_id=cp_party_site_id AND
322: hps.location_id=hzl.location_id AND

Line 582: FROM hz_locations

578:
579: CURSOR get_location_dtls(cp_location_id NUMBER) IS
580: SELECT address1, address2, address3, address4, city, province, state ,
581: county, postal_code, country, delivery_point_code
582: FROM hz_locations
583: WHERE location_id = cp_location_id;
584:
585: CURSOR get_effective_dates (cp_party_site_id NUMBER) IS
586: SELECT start_date, end_date

Line 649: --Get the current details of the Address record from HZ_LOCATIONS table and set the respective workflow NEW_ parameters.

645: aname => 'NAME',
646: avalue => rec_chk_oss_party.party_name
647: );
648:
649: --Get the current details of the Address record from HZ_LOCATIONS table and set the respective workflow NEW_ parameters.
650: OPEN get_location_dtls(rec_chk_oss_party.location_id);
651: FETCH get_location_dtls INTO rec_location_dtls;
652: CLOSE get_location_dtls;
653: