DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on BOM_CALENDAR_DATES

Line 87: bom_calendar_dates cal,

83: CURSOR c_next_working_day(c_org_id NUMBER,c_start_date DATE )
84: IS
85: SELECT DISTINCT cal.calendar_date working_date
86: FROM mtl_parameters param,
87: bom_calendar_dates cal,
88: bom_shift_times shifts
89: WHERE param.organization_id = c_org_id
90: AND TRUNC(cal.calendar_date) >= TRUNC(c_start_date)
91: AND cal.calendar_code = param.calendar_code