DBA Data[Home] [Help]

APPS.MRP_SCHEDULE_DESIG_PKG dependencies on DUAL

Line 13: FROM dual

9: BEGIN
10:
11: SELECT 1
12: INTO dummy
13: FROM dual
14: WHERE NOT EXISTS (SELECT 1
15: FROM mrp_schedule_designators
16: WHERE schedule_designator = X_schedule_designator
17: AND organization_id = X_organization_id

Line 66: FROM dual

62: entity := 1;
63:
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);

Line 77: FROM dual

73: entity := 2;
74:
75: SELECT 1
76: INTO dummy
77: FROM dual
78: WHERE NOT EXISTS (SELECT 1
79: FROM mrp_designators
80: WHERE compile_designator = X_schedule_designator
81: AND organization_id = X_organization_id);