APPS.PJI_PMV_ENGINE dependencies on PA_EXPENDITURE_CATEGORIES

Line 788: FROM PA_EXPENDITURE_CATEGORIES ;

784: Write2FWKLog('View BY EC and EC is not specified.');
785: END IF;
786: INSERT INTO PJI_PMV_EC_RC_DIM_TMP (ID, NAME,RECORD_TYPE)
787: SELECT EXPENDITURE_CATEGORY, EXPENDITURE_CATEGORY,'EC'
788: FROM PA_EXPENDITURE_CATEGORIES ;
789: l_EC_Parsed_Flag:='Y';
790: ELSIF l_ECate_Dimension_List_Tab IS NOT NULL THEN
791: IF p_PA_DEBUG_MODE = 'Y' THEN
792: Write2FWKLog('EC is specified.');

Line 797: FROM PA_EXPENDITURE_CATEGORIES

793: END IF;
794: FOR i IN 1..l_ECate_Dimension_List_Tab.Last LOOP
795: INSERT INTO PJI_PMV_EC_RC_DIM_TMP (ID, NAME,RECORD_TYPE)
796: SELECT EXPENDITURE_CATEGORY, DECODE(p_View_By, 'EC', EXPENDITURE_CATEGORY, '-1'),'EC'
797: FROM PA_EXPENDITURE_CATEGORIES
798: WHERE EXPENDITURE_CATEGORY_ID = to_number(l_ECate_Dimension_List_Tab(i));
799: /* Changed the where clause to expenditure_category_id as l_ECate_Dimension_List_Tab
800: stores expenditure_category_id in varchar form. Added for bug 6836176 */
801: END LOOP;