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;