APPS.PJI_PMV_ENGINE dependencies on PJI_JOBS_V

Line 1146: FROM PJI_JOBS_V;

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
1149: IF p_PA_DEBUG_MODE = 'Y' THEN
1150: Write2FWKLog('Creating JB rows, JL is specified.');

Line 1154: FROM PJI_JOBS_V ORIG

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;
1157: l_JB_Parsed_Flag:='Y';
1158: END IF;

Line 1173: FROM PJI_JOBS_V

1169: /*
1170: FORALL i IN 1..l_Job_Dimension_List_Tab.Last
1171: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1172: SELECT ID, DECODE(p_View_BY,'JL',VALUE,'-1')
1173: FROM PJI_JOBS_V
1174: WHERE ID = l_Job_Dimension_List_Tab(i);
1175: */
1176: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP
1177: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

Line 1179: FROM PJI_JOBS_V

1175: */
1176: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP
1177: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1178: SELECT ID, DECODE(p_View_BY,'JL',VALUE,'-1')
1179: FROM PJI_JOBS_V
1180: WHERE ID = l_Job_Dimension_List_Tab(i);
1181: END LOOP;
1182: l_JB_Parsed_Flag:='Y';
1183: ELSIF l_JL_Parsed_Flag IS NOT NULL THEN

Line 1195: FROM PJI_JOBS_V ORIG

1191: /*
1192: FORALL i IN 1..l_Job_Dimension_List_Tab.Last
1193: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1194: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1195: FROM PJI_JOBS_V ORIG
1196: , PJI_PMV_JL_DIM_TMP USRX
1197: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)
1198: AND ORIG.JOB_LEVEL=USRX.ID;
1199: */

Line 1203: FROM PJI_JOBS_V ORIG

1199: */
1200: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP
1201: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1202: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1203: FROM PJI_JOBS_V ORIG
1204: , PJI_PMV_JL_DIM_TMP USRX
1205: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)
1206: AND ORIG.JOB_LEVEL=USRX.ID;
1207: END LOOP;