DBA Data[Home] [Help]

APPS.MRP_SCHEDULE_DESIG_PKG dependencies on MRP_FORECAST_DESIGNATORS

Line 61: -- Check mrp_forecast_designators table

57: entity NUMBER;
58: dummy NUMBER;
59:
60: BEGIN
61: -- Check mrp_forecast_designators table
62: entity := 1;
63:
64: SELECT 1
65: INTO dummy

Line 68: FROM mrp_forecast_designators

64: SELECT 1
65: INTO dummy
66: FROM dual
67: WHERE NOT EXISTS (SELECT 1
68: FROM mrp_forecast_designators
69: WHERE forecast_designator = X_schedule_designator
70: AND organization_id = X_organization_id);
71:
72: -- Check mrp_designators table