APPS.PJI_PMV_ENGINE dependencies on PJI_EXP_EVT_TYPES_V

Line 643: FROM pji_exp_evt_types_v ;

639: END IF;
640:
641: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
642: SELECT ID, VALUE,'RT'
643: FROM pji_exp_evt_types_v ;
644: l_RT_Parsed_Flag:='Y';
645: ELSIF l_RC_Parsed_Flag IS NOT NULL THEN
646: IF p_PA_DEBUG_MODE = 'Y' THEN
647: Write2FWKLog('Creating RT rows, RC is specified.');

Line 651: FROM pji_exp_evt_types_v rtyp

647: Write2FWKLog('Creating RT rows, RC is specified.');
648: END IF;
649: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
650: SELECT rtyp.id, DECODE(p_View_BY,'RC',usrx.name,'RT',rtyp.value,'-1'),'RT'
651: FROM pji_exp_evt_types_v rtyp
652: , PJI_PMV_EC_RC_DIM_TMP usrx
653: WHERE rtyp.revenue_category_code = usrx.id
654: and usrx.record_type = 'RC';
655: l_RT_Parsed_Flag:='Y';

Line 668: FROM pji_exp_evt_types_v

664: END IF;
665: FOR i IN 1..l_RType_Dimension_List_Tab.Last LOOP
666: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
667: SELECT id, DECODE(p_View_BY,'RT',value,'-1'),'RT'
668: FROM pji_exp_evt_types_v
669: WHERE
670: id = l_RType_Dimension_List_Tab(i);
671: END LOOP;
672: l_RT_Parsed_Flag:='Y';

Line 680: FROM pji_exp_evt_types_v rtyp

676: END IF;
677: FOR i IN 1..l_RType_Dimension_List_Tab.Last LOOP
678: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
679: SELECT rtyp.id, DECODE(p_View_BY,'RC',usrx.name,'RT',rtyp.value,'-1'),'RT'
680: FROM pji_exp_evt_types_v rtyp
681: , PJI_PMV_EC_RC_DIM_TMP usrx
682: WHERE rtyp.id = l_RType_Dimension_List_Tab(i)
683: AND rtyp.revenue_category_code = usrx.id
684: AND usrx.record_type = 'RC';

Line 5045: G_ViewBY_Table_Name := 'PJI_EXP_EVT_TYPES_V';

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
5047: G_ViewBY_Column_Name := 'JOB_LEVEL_ID';
5048: G_ViewBY_Table_Name := 'PJI_JOB_LEVELS_V';
5049: WHEN 'PROJECT WORK TYPE+PJI_UTIL_CATEGORIES' THEN