APPS.MRP_PARAMETER_MRPEPPS dependencies on MRP_PLANS

Line 139: SELECT distinct compile_designator name from mrp_plans

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

Line 243: /* MRP PLANS */

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

Line 340: from mrp_plans

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

Line 355: from mrp_plans

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