APPS.MRP_ADJUST_DATES_PK dependencies on DUAL

Line 64: FROM dual

60: l_error_msg := error_msg;
61:
62: BEGIN
63: SELECT 'x' into string_buffer
64: FROM dual
65: WHERE exists
66: (SELECT schedule_date
67: FROM mrp_schedule_dates
68: WHERE organization_id = org_id);

Line 77: FROM dual

73: END;
74:
75: BEGIN
76: SELECT 'x' into string_buffer
77: FROM dual
78: WHERE exists
79: (SELECT forecast_date
80: FROM mrp_forecast_dates
81: WHERE organization_id = org_id);

Line 109: FROM dual

105: -- Check if enough data exists in the calendar to cover the current dates
106: -- in mrp_schedule_dates
107: IF demand_exists THEN
108: SELECT 'x' INTO string_buffer
109: FROM dual
110: WHERE NOT EXISTS
111: (SELECT schedule_date
112: FROM mrp_schedule_dates
113: WHERE organization_id = org_id

Line 130: FROM dual

126: -- in mrp_forecast_dates
127: IF forecast_exists THEN
128:
129: SELECT 'x' INTO string_buffer
130: FROM dual
131: WHERE NOT EXISTS
132: (SELECT forecast_date
133: FROM mrp_forecast_dates
134: WHERE organization_id = org_id

Line 172: from dual)

168: and orgs.planned_organization =
169: dates.organization_id
170: union all
171: select org_id
172: from dual)
173: AND desig.schedule_designator =
174: dates.schedule_designator)
175: WHERE dates.organization_id = org_id
176: AND dates.schedule_level = 2;