APPS.MRP_PARAMETER_MRPEPPS dependencies on MRP_PLANS

Line 140: SELECT distinct compile_designator name from mrp_plans

136: CURSOR c_period_types IS
137: SELECT distinct period_type name from gl_periods;
138:
139: CURSOR c_plans IS
140: SELECT distinct compile_designator name from mrp_plans
141: where data_completion_date is not null
142: and plan_completion_date is not null;
143:
144: CURSOR c_orgs IS

Line 245: /* MRP PLANS */

241: end if;
242: END LOOP;
243: params(2).Value := params(2).Value || htf.formSelectClose;
244: */
245: /* MRP PLANS */
246: /*
247: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_PLAN_NAME_LABEL' );
248: params(3).Value := htf.formSelectOpen('P_PLAN1');
249: FOR c1 in c_plans LOOP

Line 342: from mrp_plans

338: BEGIN
339:
340: select compile_designator
341: into l_plan_name
342: from mrp_plans
343: where compile_designator like P_PLAN_NAME;
344:
345: RETURN TRUE;
346:

Line 357: from mrp_plans

353: end if;
354:
355: select max(compile_designator), count(*)
356: into l_plan_name, l_count
357: from mrp_plans
358: where compile_designator like P_PLAN_NAME;
359:
360: if l_count = 1 then
361: RETURN TRUE;