479: ELSE
480: CP_BALANCE_TYPE := 'DR';
481: END IF;
482: DELETE FROM JE_HU_BALANCES_REPORT;
483: DELETE FROM FA_LOOKUPS_B
484: WHERE LOOKUP_TYPE = 'REPORT TYPE';
485: DELETE FROM FA_LOOKUPS_TL
486: WHERE LOOKUP_TYPE = 'REPORT TYPE';
487: INSERT INTO FA_LOOKUPS_B
483: DELETE FROM FA_LOOKUPS_B
484: WHERE LOOKUP_TYPE = 'REPORT TYPE';
485: DELETE FROM FA_LOOKUPS_TL
486: WHERE LOOKUP_TYPE = 'REPORT TYPE';
487: INSERT INTO FA_LOOKUPS_B
488: (LOOKUP_TYPE
489: ,LOOKUP_CODE
490: ,LAST_UPDATED_BY
491: ,LAST_UPDATE_DATE