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_GET_BIS_VALUES dependencies on MSC_BIS_PERIODS

Line 255: FROM msc_bis_periods mbp,

251: v_period_count NUMBER;
252:
253: CURSOR PERIOD_CURSOR IS
254: SELECT mbp.period_name, mbp.start_date, mbp.end_date
255: FROM msc_bis_periods mbp,
256: msc_plans mp
257: WHERE mbp.organization_id = mp.organization_id
258: and mbp.sr_instance_id = mp.sr_instance_id
259: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)

Line 856: FROM msc_bis_periods mbp,

852: Procedure populate_plan_date(p_plan_id IN NUMBER) IS
853:
854: CURSOR PERIOD_CURSOR IS
855: SELECT mbp.period_name, mbp.start_date, mbp.end_date
856: FROM msc_bis_periods mbp,
857: msc_plans mp
858: WHERE mbp.organization_id = mp.organization_id
859: and mbp.sr_instance_id = mp.sr_instance_id
860: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)

Line 871: FROM msc_bis_periods mbp,

867: order by mbp.start_date;
868:
869: CURSOR PERIOD_ZERO_CURSOR IS
870: SELECT mbp.start_date
871: FROM msc_bis_periods mbp,
872: msc_plans mp
873: WHERE mbp.organization_id = mp.organization_id
874: and mbp.sr_instance_id = mp.sr_instance_id
875: and mbp.start_date < g_plan_start_date