APPS.MSC_RP_PUB dependencies on MSC_PLAN_ORGANIZATIONS

Line 746: update MSC_plan_organizations

742: BEGIN
743: EXIT WHEN l_Counter > l_max_tries;
744: l_Counter := l_Counter + 1;
745:
746: update MSC_plan_organizations
747: set
748: program_id= msc_plan_organization_s.nextval
749: where plan_id = rp_id;
750: exit;

Line 1108: from msc_plan_organizations org where org.plan_id=arg_plan_id;

1104: 1,1)
1105: )),
1106: 1,2,
1107: 0) ss_profile_value
1108: from msc_plan_organizations org where org.plan_id=arg_plan_id;
1109:
1110: begin
1111:
1112: delete msc_plan_profiles where plan_id=p_plan_id;