APPS.JE_JEHUFAMD_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 483: DELETE FROM FA_LOOKUPS_B

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

Line 485: DELETE FROM FA_LOOKUPS_TL

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
488: (LOOKUP_TYPE
489: ,LOOKUP_CODE

Line 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

Line 498: INSERT INTO FA_LOOKUPS_TL

494: ,P_REPORT_TYPE
495: ,1
496: ,SYSDATE
497: ,'Y');
498: INSERT INTO FA_LOOKUPS_TL
499: (LOOKUP_TYPE
500: ,LOOKUP_CODE
501: ,LANGUAGE
502: ,SOURCE_LANG