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_LOCATION_PROFILES

Line 593: FROM hz_location_profiles

589:
590: CURSOR get_old_addr_dtls(cp_location_id NUMBER) IS
591: SELECT address1, address2, address3, address4, city,
592: prov_state_admin_code, county, postal_code, country
593: FROM hz_location_profiles
594: WHERE location_id = cp_location_id
595: AND SYSDATE NOT BETWEEN effective_start_date AND NVL(effective_end_date,SYSDATE)
596: ORDER BY location_profile_id DESC;
597:

Line 744: --Get the previous details of the Address record from the HZ_LOCATION_PROFILES table. And set the respective OLD_ workflow parameters.

740: aname => 'NEW_TO_DATE',
741: avalue => rec_effective_dates.end_date
742: );
743:
744: --Get the previous details of the Address record from the HZ_LOCATION_PROFILES table. And set the respective OLD_ workflow parameters.
745: OPEN get_old_addr_dtls(rec_chk_oss_party.location_id);
746: FETCH get_old_addr_dtls INTO rec_old_addr_dtls;
747: CLOSE get_old_addr_dtls;
748: