APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_JB_DIM_TMP

Line 1088: DELETE PJI_PMV_JB_DIM_TMP;

1084: IF p_PA_DEBUG_MODE = 'Y' THEN
1085: Write2FWKLog('Entering Convert_Job_Level...','Convert_Job_Level');
1086: END IF;
1087:
1088: DELETE PJI_PMV_JB_DIM_TMP;
1089: DELETE PJI_PMV_JL_DIM_TMP;
1090:
1091: IF p_Job_Level_IDS IS NOT NULL THEN
1092: l_JLevel_Dimension_List_Tab:=Decode_IDS(p_Job_Level_IDS);

Line 1144: INSERT INTO PJI_PMV_JB_DIM_TMP (ID, NAME)

1140: IF l_JL_Parsed_Flag IS NULL AND p_View_BY = 'JB' THEN
1141: IF p_PA_DEBUG_MODE = 'Y' THEN
1142: Write2FWKLog('Creating JB rows, View BY JB and JL is not specified.');
1143: END IF;
1144: INSERT INTO PJI_PMV_JB_DIM_TMP (ID, NAME)
1145: SELECT ID, VALUE
1146: FROM PJI_JOBS_V;
1147: l_JB_Parsed_Flag:='Y';
1148: ELSIF l_JL_Parsed_Flag IS NOT NULL THEN

Line 1152: INSERT INTO PJI_PMV_JB_DIM_TMP (ID, NAME)

1148: ELSIF l_JL_Parsed_Flag IS NOT NULL THEN
1149: IF p_PA_DEBUG_MODE = 'Y' THEN
1150: Write2FWKLog('Creating JB rows, JL is specified.');
1151: END IF;
1152: INSERT INTO PJI_PMV_JB_DIM_TMP (ID, NAME)
1153: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1154: FROM PJI_JOBS_V ORIG
1155: , PJI_PMV_JL_DIM_TMP USRX
1156: WHERE ORIG.JOB_LEVEL=USRX.ID;