DBA Data[Home] [Help]

APPS.INVWATP dependencies on HR_ORGANIZATION_UNITS

Line 155: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL

151: begin
152: -- calendar organization id
153: SELECT MTL.ORGANIZATION_ID
154: into rec_mgav.atp_calendar_organization_id
155: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL
156: WHERE HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
157: AND MTL.CALENDAR_CODE is not null
158: AND MTL.CALENDAR_EXCEPTION_SET_ID is not null
159: AND MTL.ORGANIZATION_ID = x_organization_id;