APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on MSC_PLAN_ORGANIZATIONS

Line 147: SELECT organization_id FROM msc_plan_organizations

143:
144:
145: -- Bug: 9458217 Vpedarla Plan_id is used
146: CURSOR org_select(C_plan_id in NUMBER ,C_inst_id in NUMBER , C_plan_org in NUMBER ) is
147: SELECT organization_id FROM msc_plan_organizations
148: WHERE plan_id = C_plan_id
149: AND sr_instance_id = C_inst_id
150: AND (C_plan_org = -999 or C_plan_org = organization_id ) ;
151:

Line 545: x_select := x_select || ' AND msi.organization_id IN (SELECT organization_id FROM msc_plan_organizations '||

541: ' AND mic.category_set_id = :cat_set_id ' ;
542: IF G_plan_org <> -999 THEN
543: x_select := x_select || ' AND msi.organization_id = :plan_org ';
544: ELSE
545: x_select := x_select || ' AND msi.organization_id IN (SELECT organization_id FROM msc_plan_organizations '||
546: ' WHERE plan_id = :plan_id AND '||
547: ' sr_instance_id = :inst_id) ';
548: END IF;
549: IF G_category_low IS NOT NULL THEN