APPS.PJI_PMV_ENGINE dependencies on PJI_REVENUE_CATEGORIES_V

Line 616: FROM pji_revenue_categories_v ;

612: Write2FWKLog('step6','step6');
613: END IF;
614: INSERT INTO PJI_PMV_EC_RC_DIM_TMP (ID, NAME,RECORD_TYPE)
615: SELECT ID, VALUE,'RC'
616: FROM pji_revenue_categories_v ;
617: l_RC_Parsed_Flag:='Y';
618: ELSIF l_RCate_Dimension_List_Tab IS NOT NULL THEN
619: IF p_PA_DEBUG_MODE = 'Y' THEN
620: Write2FWKLog('RC is specified.');

Line 625: FROM pji_revenue_categories_v

621: END IF;
622: FOR i IN 1..l_RCate_Dimension_List_Tab.Last LOOP
623: INSERT INTO PJI_PMV_EC_RC_DIM_TMP (ID, NAME,RECORD_TYPE)
624: SELECT ID, DECODE(p_View_By, 'RC', VALUE, '-1'),'RC'
625: FROM pji_revenue_categories_v
626: WHERE ID = l_RCate_Dimension_List_Tab(i);
627: END LOOP;
628: l_RC_Parsed_Flag:='Y';
629: END IF;

Line 5042: G_ViewBY_Table_Name := 'PJI_REVENUE_CATEGORIES_V';

5038: G_ViewBY_Column_Name := 'EXPENDITURE_TYPE_ID';
5039: G_ViewBY_Table_Name := 'PJI_EXP_TYPES_V';
5040: WHEN 'PROJECT REVENUE CATEGORY+PJI_REVENUE_CATEGORIES' THEN
5041: G_ViewBY_Column_Name := 'REVENUE_CATEGORY';
5042: G_ViewBY_Table_Name := 'PJI_REVENUE_CATEGORIES_V';
5043: WHEN 'PROJECT REVENUE CATEGORY+PJI_EXP_EVT_TYPES' THEN
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