DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on PJI_WORK_TYPES_V

Line 724: FROM PJI_WORK_TYPES_V WT

720: l_Dimension_List_Tab:=Decode_IDS(p_Work_Type_IDS);
721: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
722: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
723: SELECT WT.ID, DECODE(p_View_BY,'WT',WT.VALUE,'-1')
724: FROM PJI_WORK_TYPES_V WT
725: WHERE WT.ID = l_Dimension_List_Tab(i);
726: END LOOP;
727: ELSE
728: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

Line 730: FROM PJI_WORK_TYPES_V WT ;

726: END LOOP;
727: ELSE
728: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
729: SELECT WT.ID, WT.VALUE
730: FROM PJI_WORK_TYPES_V WT ;
731: END IF;
732:
733: END IF;
734: RETURN l_Parse_Status;

Line 5054: G_ViewBY_Table_Name := 'PJI_WORK_TYPES_V';

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
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