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.BIS_PMF_DEFINER_WRAPPER_PVT dependencies on BIS_INDICATOR_DIMENSIONS

Line 1484: FROM bis_indicator_dimensions x, bis_dimensions y

1480: )
1481: IS
1482: CURSOR c_perf_dim_src IS
1483: SELECT x.sequence_no
1484: FROM bis_indicator_dimensions x, bis_dimensions y
1485: WHERE x.indicator_id = p_performance_measure_id AND
1486: y.dimension_id = x.dimension_id AND
1487: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source);
1488: CURSOR c_perf_dim IS

Line 1490: FROM bis_indicator_dimensions x, bis_dimensions y

1486: y.dimension_id = x.dimension_id AND
1487: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source);
1488: CURSOR c_perf_dim IS
1489: SELECT x.sequence_no
1490: FROM bis_indicator_dimensions x, bis_dimensions y
1491: WHERE x.indicator_id = p_performance_measure_id AND
1492: y.dimension_id = x.dimension_id AND
1493: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);
1494: CURSOR c_dim IS

Line 1503: FROM bis_indicator_dimensions x, bisfv_target_levels y,

1499: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
1500: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
1501: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
1502: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
1503: FROM bis_indicator_dimensions x, bisfv_target_levels y,
1504: bis_dimensions z
1505: WHERE y.target_level_id=p_target_level_id AND
1506: y.measure_id = x.indicator_id AND
1507: x.dimension_id = z.dimension_id AND

Line 1669: FROM bis_indicator_dimensions x, bis_dimensions y

1665: )
1666: IS
1667: CURSOR c_perf_dim IS
1668: SELECT x.sequence_no
1669: FROM bis_indicator_dimensions x, bis_dimensions y
1670: WHERE x.indicator_id = p_performance_measure_id AND
1671: y.dimension_id = x.dimension_id AND
1672: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);
1673: CURSOR c_dim IS

Line 1682: FROM bis_indicator_dimensions x, bisfv_target_levels y,

1678: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
1679: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
1680: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
1681: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
1682: FROM bis_indicator_dimensions x, bisfv_target_levels y,
1683: bis_dimensions z
1684: WHERE y.target_level_id=p_target_level_id AND
1685: y.measure_id = x.indicator_id AND
1686: x.dimension_id = z.dimension_id AND

Line 1810: FROM bis_indicator_dimensions x, bis_dimensions y

1806: )
1807: IS
1808: CURSOR c_perf_dim_src IS
1809: SELECT x.sequence_no
1810: FROM bis_indicator_dimensions x, bis_dimensions y
1811: WHERE x.indicator_id = p_performance_measure_id AND
1812: y.dimension_id = x.dimension_id AND
1813: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_SRC(p_source);
1814: CURSOR c_perf_dim IS

Line 1816: FROM bis_indicator_dimensions x, bis_dimensions y

1812: y.dimension_id = x.dimension_id AND
1813: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_SRC(p_source);
1814: CURSOR c_perf_dim IS
1815: SELECT x.sequence_no
1816: FROM bis_indicator_dimensions x, bis_dimensions y
1817: WHERE x.indicator_id = p_performance_measure_id AND
1818: y.dimension_id = x.dimension_id AND
1819: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);
1820: CURSOR c_dim IS

Line 1829: FROM bis_indicator_dimensions x, bisfv_target_levels y,

1825: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
1826: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
1827: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
1828: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
1829: FROM bis_indicator_dimensions x, bisfv_target_levels y,
1830: bis_dimensions z
1831: WHERE y.target_level_id=p_target_level_id AND
1832: y.measure_id = x.indicator_id AND
1833: x.dimension_id = z.dimension_id AND

Line 1997: FROM bis_indicator_dimensions x, bis_dimensions y

1993: )
1994: IS
1995: CURSOR c_perf_dim IS
1996: SELECT x.sequence_no
1997: FROM bis_indicator_dimensions x, bis_dimensions y
1998: WHERE x.indicator_id = p_performance_measure_id AND
1999: y.dimension_id = x.dimension_id AND
2000: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);
2001: CURSOR c_dim IS

Line 2010: FROM bis_indicator_dimensions x, bisfv_target_levels y,

2006: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
2007: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
2008: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
2009: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
2010: FROM bis_indicator_dimensions x, bisfv_target_levels y,
2011: bis_dimensions z
2012: WHERE y.target_level_id=p_target_level_id AND
2013: y.measure_id = x.indicator_id AND
2014: x.dimension_id = z.dimension_id AND