APPS.JE_JEHUFAMS_XMLP_PKG dependencies on FA_LOOKUPS

Line 270: FA_LOOKUPS RT,

266: ,CP_BALANCE_TYPE
267: ,1
268: ,-1) * AJ.ADJUSTMENT_AMOUNT)
269: FROM
270: FA_LOOKUPS RT,
271: FA_DISTRIBUTION_HISTORY DH,
272: FA_TRANSACTION_HEADERS TH,
273: FA_ASSET_HISTORY AH,
274: FA_ADJUSTMENTS AJ,

Line 400: FA_LOOKUPS RT,

396: ,DD.DEPRN_AMOUNT
397: ,'REVAL RESERVE'
398: ,-DD.REVAL_AMORTIZATION))
399: FROM
400: FA_LOOKUPS RT,
401: FA_CATEGORY_BOOKS CB,
402: FA_DISTRIBUTION_HISTORY DH,
403: FA_ASSET_HISTORY AH,
404: FA_DEPRN_DETAIL DD,

Line 477: DELETE FROM FA_LOOKUPS_B

473: ELSE
474: CP_BALANCE_TYPE := 'DR';
475: END IF;
476: DELETE FROM JE_HU_BALANCES_REPORT;
477: DELETE FROM FA_LOOKUPS_B
478: WHERE LOOKUP_TYPE = 'REPORT TYPE';
479: DELETE FROM FA_LOOKUPS_TL
480: WHERE LOOKUP_TYPE = 'REPORT TYPE';
481: INSERT INTO FA_LOOKUPS_B

Line 479: DELETE FROM FA_LOOKUPS_TL

475: END IF;
476: DELETE FROM JE_HU_BALANCES_REPORT;
477: DELETE FROM FA_LOOKUPS_B
478: WHERE LOOKUP_TYPE = 'REPORT TYPE';
479: DELETE FROM FA_LOOKUPS_TL
480: WHERE LOOKUP_TYPE = 'REPORT TYPE';
481: INSERT INTO FA_LOOKUPS_B
482: (LOOKUP_TYPE
483: ,LOOKUP_CODE

Line 481: INSERT INTO FA_LOOKUPS_B

477: DELETE FROM FA_LOOKUPS_B
478: WHERE LOOKUP_TYPE = 'REPORT TYPE';
479: DELETE FROM FA_LOOKUPS_TL
480: WHERE LOOKUP_TYPE = 'REPORT TYPE';
481: INSERT INTO FA_LOOKUPS_B
482: (LOOKUP_TYPE
483: ,LOOKUP_CODE
484: ,LAST_UPDATED_BY
485: ,LAST_UPDATE_DATE

Line 492: INSERT INTO FA_LOOKUPS_TL

488: ,P_REPORT_TYPE
489: ,1
490: ,SYSDATE
491: ,'Y');
492: INSERT INTO FA_LOOKUPS_TL
493: (LOOKUP_TYPE
494: ,LOOKUP_CODE
495: ,LANGUAGE
496: ,SOURCE_LANG