APPS.PJI_PMV_ENGINE dependencies on PA_WORK_TYPES_TL

Line 967: FROM pa_work_types_tl

963: Write2FWKLog('Creating WT rows, View BY WT and UC is not specified.');
964: END IF;
965: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
966: SELECT work_type_id, name
967: FROM pa_work_types_tl
968: WHERE
969: LANGUAGE = USERENV('LANG');
970: l_WT_Parsed_Flag:='Y';
971: ELSIF l_UC_Parsed_Flag IS NOT NULL THEN

Line 977: FROM pa_work_types_tl orig_tl

973: Write2FWKLog('Creating WT rows, UC is specified.');
974: END IF;
975: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
976: SELECT orig.work_type_id, DECODE(p_View_BY,'UC',usrx.name,'WT',orig_tl.name,'-1')
977: FROM pa_work_types_tl orig_tl
978: , pa_work_types_b orig
979: , pji_pmv_uc_dim_tmp usrx
980: WHERE
981: LANGUAGE = USERENV('LANG')

Line 1002: FROM pa_work_types_tl

998: /*
999: FORALL i IN 1..l_WType_Dimension_List_Tab.Last
1000: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1001: SELECT work_type_id, DECODE(p_View_BY,'WT',name,'-1')
1002: FROM pa_work_types_tl
1003: WHERE
1004: LANGUAGE = USERENV('LANG')
1005: AND work_type_id = l_WType_Dimension_List_Tab(i);
1006: */

Line 1010: FROM pa_work_types_tl

1006: */
1007: FOR i IN 1..l_WType_Dimension_List_Tab.Last LOOP
1008: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1009: SELECT work_type_id, DECODE(p_View_BY,'WT',name,'-1')
1010: FROM pa_work_types_tl
1011: WHERE
1012: LANGUAGE = USERENV('LANG')
1013: AND work_type_id = l_WType_Dimension_List_Tab(i);
1014: END LOOP;

Line 1028: FROM pa_work_types_tl orig_tl

1024: /*
1025: FORALL i IN 1..l_WType_Dimension_List_Tab.Last
1026: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1027: SELECT orig.work_type_id, DECODE(p_View_BY,'UC',usrx.name,'WT',orig_tl.name,'-1')
1028: FROM pa_work_types_tl orig_tl
1029: , pa_work_types_b orig
1030: , pji_pmv_uc_dim_tmp usrx
1031: WHERE
1032: LANGUAGE = USERENV('LANG')

Line 1040: FROM pa_work_types_tl orig_tl

1036: */
1037: FOR i IN 1..l_WType_Dimension_List_Tab.Last LOOP
1038: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1039: SELECT orig.work_type_id, DECODE(p_View_BY,'UC',usrx.name,'WT',orig_tl.name,'-1')
1040: FROM pa_work_types_tl orig_tl
1041: , pa_work_types_b orig
1042: , pji_pmv_uc_dim_tmp usrx
1043: WHERE
1044: LANGUAGE = USERENV('LANG')