eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ANALYSIS_PKG dependencies on MSC_BIS_PERIODS

Line 225: FROM msc_bis_periods mbp,

221:
222: CURSOR totalBisPerCur(p_plan_id in NUMBER)
223: IS
224: SELECT count(distinct mbp.period_name)
225: FROM msc_bis_periods mbp,
226: msc_plans mp
227: WHERE mbp.organization_id = mp.organization_id
228: and mbp.sr_instance_id = mp.sr_instance_id
229: and ((mbp.start_date between nvl(mp.curr_start_date, sysdate)

Line 1325: FROM msc_bis_periods mbp,

1321: l_calc_gross_profit_pct number;
1322:
1323: CURSOR PERIOD_CURSOR (p_plan_id in number) IS
1324: SELECT count(*)
1325: FROM msc_bis_periods mbp,
1326: msc_plans mp
1327: WHERE mbp.organization_id = mp.organization_id
1328: and mbp.sr_instance_id = mp.sr_instance_id
1329: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)