DBA Data[Home] [Help]

APPS.PAY_DK_ABSR_PKG dependencies on HR_LOCATIONS

Line 233: , HR_LOCATIONS loc

229: ,loc.postal_code PCODE
230: FROM HR_ORGANIZATION_UNITS hou1
231: , HR_ORGANIZATION_INFORMATION hoi1
232: , HR_ORGANIZATION_INFORMATION hoi2
233: , HR_LOCATIONS loc
234: WHERE hou1.business_group_id = p_business_group_id
235: and hou1.organization_id = nvl(p_sender_id ,hou1.organization_id)
236: and hou1.location_id = loc.LOCATION_ID(+)
237: and hoi1.organization_id = hou1.organization_id

Line 259: , HR_LOCATIONS loc

255: ,loc.postal_code PCODE
256: FROM HR_ORGANIZATION_UNITS hou
257: , HR_ORGANIZATION_INFORMATION hoi1
258: , HR_ORGANIZATION_INFORMATION hoi2
259: , HR_LOCATIONS loc
260: WHERE hou.business_group_id = p_business_group_id
261: and hoi1.organization_id = hou.organization_id
262: and hou.location_id = loc.LOCATION_ID(+)
263: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'