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.ZX_PTP_IMPORT dependencies on HR_LOCATIONS

Line 3343: FROM hr_locations loc

3339: WHERE (( legal_location_id IS NOT NULL
3340: AND NOT EXISTS
3341: (
3342: SELECT 1
3343: FROM hr_locations loc
3344: WHERE legal_address_flag = 'Y'
3345: AND SYSDATE < nvl(inactive_date, SYSDATE + 1)
3346: AND loc.location_id = reg_int.legal_location_id
3347: )

Line 3359: FROM hr_locations

3355: )
3356: AND NOT EXISTS
3357: (
3358: SELECT 1
3359: FROM hr_locations
3360: WHERE legal_address_flag = 'Y'
3361: AND SYSDATE < nvl(inactive_date, SYSDATE + 1)
3362: AND legal_location_code = reg_int.legal_location_code
3363: AND NVL(address_line_1,G_MISS_CHAR) = NVL(reg_int.address_line_1,G_MISS_CHAR)

Line 3381: FROM hr_locations

3377: -- value to id conversion for legal_location_id
3378: UPDATE zx_registrations_int reg_int
3379: SET legal_location_id = (
3380: SELECT legal_location_id
3381: FROM hr_locations
3382: WHERE legal_address_flag = 'Y'
3383: AND SYSDATE < nvl(inactive_date, SYSDATE + 1)
3384: AND legal_location_code = reg_int.legal_location_code
3385: AND NVL(address_line_1,G_MISS_CHAR) =