APPS.PJI_PMV_ENGINE dependencies on PJI_JOB_LEVELS_V

Line 1109: FROM PJI_JOB_LEVELS_V;

1105: Write2FWKLog('View BY JL and JL is not specified.');
1106: END IF;
1107: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1108: SELECT ID, VALUE
1109: FROM PJI_JOB_LEVELS_V;
1110: l_JL_Parsed_Flag:='Y';
1111: ELSIF l_JLevel_Dimension_List_Tab IS NOT NULL THEN
1112: IF p_PA_DEBUG_MODE = 'Y' THEN
1113: Write2FWKLog('JL is specified.');

Line 1123: FROM PJI_JOB_LEVELS_V

1119: /*
1120: FORALL i IN 1..l_JLevel_Dimension_List_Tab.Last
1121: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1122: SELECT ID,DECODE(p_View_By, 'JL', VALUE , '-1')
1123: FROM PJI_JOB_LEVELS_V
1124: WHERE ID = l_JLevel_Dimension_List_Tab(i);
1125: */
1126: FOR i IN 1..l_JLevel_Dimension_List_Tab.Last LOOP
1127: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

Line 1129: FROM PJI_JOB_LEVELS_V

1125: */
1126: FOR i IN 1..l_JLevel_Dimension_List_Tab.Last LOOP
1127: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1128: SELECT ID,DECODE(p_View_By, 'JL', VALUE , '-1')
1129: FROM PJI_JOB_LEVELS_V
1130: WHERE ID = l_JLevel_Dimension_List_Tab(i);
1131: END LOOP;
1132: l_JL_Parsed_Flag:='Y';
1133: END IF;

Line 5048: G_ViewBY_Table_Name := 'PJI_JOB_LEVELS_V';

5044: G_ViewBY_Column_Name := 'REVENUE_TYPE_ID';
5045: G_ViewBY_Table_Name := 'PJI_EXP_EVT_TYPES_V';
5046: WHEN 'PROJECT JOB LEVEL+PJI_JOB_LEVELS' THEN
5047: G_ViewBY_Column_Name := 'JOB_LEVEL_ID';
5048: G_ViewBY_Table_Name := 'PJI_JOB_LEVELS_V';
5049: WHEN 'PROJECT WORK TYPE+PJI_UTIL_CATEGORIES' THEN
5050: G_ViewBY_Column_Name := 'UTIL_CATEGORY_ID';
5051: G_ViewBY_Table_Name := 'PJI_UTIL_CATEGORIES_V';
5052: WHEN 'PROJECT WORK TYPE+PJI_WORK_TYPES' THEN