APPS.PJI_PMV_ENGINE dependencies on PA_UTIL_CATEGORIES_TL

Line 924: FROM pa_util_categories_tl

920: Write2FWKLog('View BY UC and UC is not specified.');
921: END IF;
922: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)
923: SELECT util_category_id, name
924: FROM pa_util_categories_tl
925: WHERE
926: LANGUAGE = USERENV('LANG');
927: l_UC_Parsed_Flag:='Y';
928: ELSIF l_Util_Dimension_List_Tab IS NOT NULL THEN

Line 940: FROM pa_util_categories_tl

936: /*
937: FORALL i IN 1..l_Util_Dimension_List_Tab.Last
938: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)
939: SELECT util_category_id, DECODE(p_View_By, 'UC', name , '-1')
940: FROM pa_util_categories_tl
941: WHERE
942: LANGUAGE = USERENV('LANG')
943: AND util_category_id = l_Util_Dimension_List_Tab(i);
944: */

Line 948: FROM pa_util_categories_tl

944: */
945: FOR i IN 1..l_Util_Dimension_List_Tab.Last LOOP
946: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)
947: SELECT util_category_id, DECODE(p_View_By, 'UC', name , '-1')
948: FROM pa_util_categories_tl
949: WHERE
950: LANGUAGE = USERENV('LANG')
951: AND util_category_id = l_Util_Dimension_List_Tab(i);
952: END LOOP;