DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on HR_LOCATIONS

Line 316: , HR_LOCATIONS loc

312: ,loc.postal_code PCODE
313: FROM HR_ORGANIZATION_UNITS hou1
314: , HR_ORGANIZATION_INFORMATION hoi1
315: , HR_ORGANIZATION_INFORMATION hoi2
316: , HR_LOCATIONS loc
317: WHERE hou1.business_group_id = p_business_group_id
318: and hou1.organization_id = nvl(p_sender_id ,hou1.organization_id)
319: and hou1.location_id = loc.LOCATION_ID(+)
320: and hoi1.organization_id = hou1.organization_id

Line 342: , HR_LOCATIONS loc

338: ,loc.postal_code PCODE
339: FROM HR_ORGANIZATION_UNITS hou
340: , HR_ORGANIZATION_INFORMATION hoi1
341: , HR_ORGANIZATION_INFORMATION hoi2
342: , HR_LOCATIONS loc
343: WHERE hou.business_group_id = p_business_group_id
344: and hoi1.organization_id = hou.organization_id
345: and hou.location_id = loc.LOCATION_ID(+)
346: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'