APPS.BIS_PMF_MIGRATION_PUB dependencies on BIS_TARGET_VALUES

Line 43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE

39: --
40: TYPE target_rec IS RECORD (
41: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
42: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE

Line 44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE

40: TYPE target_rec IS RECORD (
41: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
42: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE

Line 45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE

41: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
42: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE

Line 46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE

42: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
50: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE

Line 47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE

43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
50: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
51: );

Line 48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE

44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
50: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
51: );
52: --

Line 49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE

45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
50: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
51: );
52: --
53: TYPE resequenced_dimensions IS RECORD (

Line 50: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE

46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
50: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
51: );
52: --
53: TYPE resequenced_dimensions IS RECORD (
54: dim_level_col VARCHAR2(20000)