APPS.MSC_PHUB_UTIL dependencies on MSC_PLANS

Line 164: msc_plans mp

160: l_plan_constrained number;
161: begin
162: select count(1) into l_plan_constrained
163: from
164: msc_plans mp
165: where
166: mp.plan_id = p_plan_id
167: and( nvl(mp.daily_resource_constraints,0 ) = 1
168: or nvl(mp.weekly_resource_constraints,0) = 1

Line 187: msc_plans

183: begin
184: select CURR_PLAN_TYPE
185: into l_plan_type
186: from
187: msc_plans
188: where
189: plan_id = p_plan_id;
190: return l_plan_type;
191: end get_plan_type;