DBA Data[Home] [Help]

APPS.FTE_LOCATION_PARAMETERS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 211: FROM wsh_locations wl, hr_organization_units hou,

207: SELECT hou.name company_name,
208: hou.name site,
209: hou.creation_date cdate,
210: 'ORGANIZATION' company_type
211: FROM wsh_locations wl, hr_organization_units hou,
212: HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP
213: WHERE wl.source_location_id = p_location_id
214: AND wl.location_source_code = 'HR'
215: AND wl.source_location_id = hou.location_id

Line 351: FROM wsh_locations wl, hr_organization_units hou,

347: wl.wsh_location_id LocId,
348: hou.name Site,
349: hou.creation_date Cdate,
350: 'ORGANIZATION' Company_Type
351: FROM wsh_locations wl, hr_organization_units hou,
352: HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,fte_location_parameters flp
353: WHERE wl.wsh_location_id = flp.location_id(+)
354: AND flp.location_id IS NULL
355: AND wl.location_source_code = 'HR'