APPS.PJI_PMV_ENGINE dependencies on PA_EXPENDITURE_TYPES

Line 817: FROM PA_EXPENDITURE_TYPES ;

813: END IF;
814:
815: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
816: SELECT EXPENDITURE_TYPE_ID, EXPENDITURE_TYPE,'ET'
817: FROM PA_EXPENDITURE_TYPES ;
818: l_ET_Parsed_Flag:='Y';
819: ELSIF l_EC_Parsed_Flag IS NOT NULL THEN
820: IF p_PA_DEBUG_MODE = 'Y' THEN
821: Write2FWKLog('Creating ET rows, EC is specified.');

Line 827: FROM pa_expenditure_types etyp

823: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
824: SELECT etyp.expenditure_type_id,
825:
826: DECODE(p_View_BY,'EC',usrx.name,'ET',etyp.expenditure_type,'-1'),'ET'
827: FROM pa_expenditure_types etyp
828: , PJI_PMV_EC_RC_DIM_TMP usrx
829: WHERE etyp.expenditure_category = usrx.id
830: and usrx.record_type = 'EC';
831: l_ET_Parsed_Flag:='Y';

Line 844: FROM pa_expenditure_types

840: END IF;
841: FOR i IN 1..l_EType_Dimension_List_Tab.Last LOOP
842: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
843: SELECT expenditure_type_id, DECODE(p_View_BY,'ET',expenditure_type,'-1'),'ET'
844: FROM pa_expenditure_types
845: WHERE
846: expenditure_type_id = l_EType_Dimension_List_Tab(i);
847: END LOOP;
848: l_ET_Parsed_Flag:='Y';

Line 858: FROM pa_expenditure_types etyp

854: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
855: SELECT etyp.expenditure_type_id,
856:
857: DECODE(p_View_BY,'EC',usrx.name,'ET',etyp.expenditure_type,'-1'),'ET'
858: FROM pa_expenditure_types etyp
859: , PJI_PMV_EC_RC_DIM_TMP usrx
860: WHERE etyp.expenditure_type_id = l_EType_Dimension_List_Tab(i)
861: AND etyp.expenditure_category = usrx.id
862: AND usrx.record_type = 'EC';