1684: g_user_id,
1685: sysdate,
1686: g_user_id,
1687: to_number(null)
1688: FROM msc_cost_breakdown_notpcost_v
1689: WHERE plan_id = p_plan_id
1690: and nvl(detail_level,0) = 0
1691: and nvl(period_type,0) = 1
1692: GROUP BY plan_id, plan_name, period_type,period_type, detail_level,category_set_id, category_id,category_name;
1733: g_user_id,
1734: sysdate,
1735: g_user_id,
1736: to_number(null)
1737: FROM msc_cost_breakdown_notpcost_v
1738: WHERE plan_id = p_plan_id
1739: and nvl(detail_level,0) = 0
1740: and nvl(period_type,0) = 0
1741: GROUP BY plan_id, plan_name, period_type,period_type, detail_level,category_set_id,category_id,category_name;