DBA Data[Home] [Help]

APPS.MSC_PHUB_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 134: from msc_system_items msi

130: l_list_price number;
131: begin
132: select nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100))
133: into l_list_price
134: from msc_system_items msi
135: where
136: msi.plan_id =p_plan_id
137: and msi.sr_instance_id = p_inst_id
138: and msi.organization_id = p_org_id