APPS.PJI_PMV_ENGINE dependencies on PA_WORK_TYPES_B

Line 978: , pa_work_types_b orig

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')
982: AND orig.work_type_id = orig_tl.work_type_id

Line 1029: , pa_work_types_b orig

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')
1033: AND orig.work_type_id = l_WType_Dimension_List_Tab(i)

Line 1041: , pa_work_types_b orig

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')
1045: AND orig.work_type_id = l_WType_Dimension_List_Tab(i)