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.PAY_NO_ARCHIVE_RSEA dependencies on HR_LOOKUPS

Line 292: ,hr_lookups hlu

288: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) , LENGTH(hlu.MEANING) -(INSTR(hlu.MEANING,' ', 1,1) -1) ) POSTAL_OFFICE
289: FROM hr_organization_units o1
290: , hr_locations hoi1
291: ,hr_organization_information hoi2
292: ,hr_lookups hlu
293: WHERE o1.business_group_id = l_business_group_id
294: AND hoi1.location_id = o1.location_id
295: AND hoi2.organization_id = o1.organization_id
296: AND hoi2.organization_id = csr_v_legal_emp_id

Line 315: ,hr_lookups hlu

311: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) ) POSTAL_OFFICE
312: FROM hr_organization_units o1
313: , hr_locations hoi1
314: ,hr_organization_information hoi2
315: ,hr_lookups hlu
316: WHERE o1.business_group_id = l_business_group_id
317: AND hoi1.location_id = o1.location_id
318: AND hoi2.organization_id = o1.organization_id
319: AND hoi2.organization_id = csr_v_tax_office_id

Line 476: FROM hr_lookups

472: AND r.row_low_range_or_name = p_municipal_no
473: AND l_effective_date BETWEEN r.effective_start_date AND r.effective_end_date;
474:
475: /* SELECT SUBSTR( meaning ,1,1) zone , TRIM(SUBSTR( meaning ,2)) municipal_name
476: FROM hr_lookups
477: WHERE lookup_type='NO_TAX_MUNICIPALITY'
478: AND enabled_flag='Y'
479: AND lookup_code = p_municipal_no;
480: */