DBA Data[Home] [Help]

APPS.CZ_ATP_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 96: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL

92: -- retrieve calendar organization ID
93: begin
94: SELECT MTL.ORGANIZATION_ID
95: into rec_mgav.atp_calendar_organization_id
96: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL
97: WHERE HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
98: AND MTL.CALENDAR_CODE is not null
99: AND MTL.CALENDAR_EXCEPTION_SET_ID is not null
100: AND MTL.ORGANIZATION_ID = p_organization_id;