DBA Data[Home] [Help]

APPS.CTO_ATP_INTERFACE_PK dependencies on BOM_CALENDAR_DATES

Line 4835: from bom_calendar_dates cal,

4831: -- set in the Oe validation org.
4832:
4833: select min(calendar_date), max(calendar_date)
4834: into l_eff_date, l_disable_date
4835: from bom_calendar_dates cal,
4836: mtl_parameters mp
4837: where mp.organization_id = CTO_ATP_INTERFACE_PK.G_OE_VALIDATION_ORG
4838: and mp.calendar_code = cal.calendar_code
4839: and mp.calendar_exception_set_id = cal.exception_set_id;

Line 5336: from bom_calendar_dates cal,

5332: -- set in the Oe validation org.
5333:
5334: select max(calendar_date)
5335: into l_disable_date
5336: from bom_calendar_dates cal,
5337: mtl_parameters mp
5338: where mp.organization_id = CTO_ATP_INTERFACE_PK.G_OE_VALIDATION_ORG
5339: and mp.calendar_code = cal.calendar_code
5340: and mp.calendar_exception_set_id = cal.exception_set_id;