DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on PJI_PROJECTS_V

Line 1870: FROM PJI_PROJECTS_V;

1866: Write2FWKLog('Creating ALL PJs, PJ array is empty');
1867: END IF;
1868: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)
1869: SELECT ID, DECODE(p_View_BY,'PJ',VALUE,'-1')
1870: FROM PJI_PROJECTS_V;
1871: */
1872: IF l_Dimension_List_Tab IS NOT NULL THEN
1873: IF p_PA_DEBUG_MODE = 'Y' THEN
1874: Write2FWKLog('Creating Selected PJs, PJ array is not empty');

Line 1884: FROM PJI_PROJECTS_V

1880: /*
1881: FORALL i IN 1..l_Dimension_List_Tab.Last
1882: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)
1883: SELECT ID, DECODE(p_View_BY,'OU',VALUE,'-1')
1884: FROM PJI_PROJECTS_V
1885: WHERE
1886: ID=l_Dimension_List_Tab(i);
1887: */
1888: FOR i IN 1..l_Dimension_List_Tab.Last LOOP

Line 1891: FROM PJI_PROJECTS_V

1887: */
1888: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
1889: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)
1890: SELECT ID, DECODE(p_View_BY,'OU',VALUE,'-1')
1891: FROM PJI_PROJECTS_V
1892: WHERE
1893: ID=l_Dimension_List_Tab(i);
1894: END LOOP;
1895: END IF;

Line 5057: G_ViewBY_Table_Name := 'PJI_PROJECTS_V';

5053: G_ViewBY_Column_Name := 'WORK_TYPE_ID';
5054: G_ViewBY_Table_Name := 'PJI_WORK_TYPES_V';
5055: WHEN 'PROJECT+PJI_PROJECTS' THEN
5056: G_ViewBY_Column_Name := 'PROJECT_NAME';
5057: G_ViewBY_Table_Name := 'PJI_PROJECTS_V';
5058: WHEN 'TIME+FII_TIME_CAL_PERIOD' THEN
5059: G_ViewBY_Column_Name := 'TIME_ID';
5060: G_ViewBY_Table_Name := 'FII_TIME_CAL_PERIOD_V';
5061: WHEN 'TIME+FII_TIME_CAL_QTR' THEN