DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_LOOKUPS

Line 423: ,hr_lookups hlu

419: ,SUBSTR(hlu.meaning, INSTR(hlu.meaning,' ', 1,1), LENGTH(hlu.meaning)-(INSTR(hlu.meaning,' ', 1,1)-1)) postal_office
420: FROM hr_organization_units o1
421: ,hr_locations hoi1
422: ,hr_organization_information hoi2
423: ,hr_lookups hlu
424: WHERE o1.business_group_id = l_business_group_id
425: AND hoi1.location_id = o1.location_id
426: AND hoi2.organization_id = o1.organization_id
427: AND hoi2.organization_id = csr_v_legal_emp_id