DBA Data[Home] [Help]

APPS.INV_LABEL_PVT7 dependencies on HR_LOCATIONS_ALL

Line 339: from hr_locations_all loc

335: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
336: AND LOOKUP_CODE = LOC.REGION_1
337: AND ROWNUM < 2),
338: LOC.REGION_3) PROVINCE -- Modified for bug 7281160
339: from hr_locations_all loc
340: union all
341: select hz.location_id location_id,hz.address1 address_line_1
342: ,hz.address2 address_line_2,hz.address3 address_line_3
343: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code

Line 364: from hr_locations_all loc

360: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
361: AND LOOKUP_CODE = LOC.REGION_1
362: AND ROWNUM < 2),
363: LOC.REGION_3) PROVINCE -- Modified for bug 7281160
364: from hr_locations_all loc
365: union all
366: select hz.location_id location_id,hz.address1 address_line_1
367: ,hz.address2 address_line_2,hz.address3 address_line_3
368: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code