DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_LOOKUPS

Line 409: ,hr_lookups hlu

405: ,SUBSTR(hlu.meaning, INSTR(hlu.meaning,' ', 1,1), LENGTH(hlu.meaning)-(INSTR(hlu.meaning,' ', 1,1)-1)) postal_office
406: FROM hr_organization_units o1
407: ,hr_locations hoi1
408: ,hr_organization_information hoi2
409: ,hr_lookups hlu
410: WHERE o1.business_group_id = l_business_group_id
411: AND hoi1.location_id = o1.location_id
412: AND hoi2.organization_id = o1.organization_id
413: AND hoi2.organization_id = csr_v_legal_emp_id