APPS.JA_JAAUFREV_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 37: FA_ADJUSTMENTS ADJ

33: ,'DR'
34: ,ADJ.ADJUSTMENT_AMOUNT)
35: INTO L_NEW_DEP_RSV
36: FROM
37: FA_ADJUSTMENTS ADJ
38: WHERE ADJ.TRANSACTION_HEADER_ID = TH_ID
39: AND ADJ.BOOK_TYPE_CODE = C_NEW_DEP_RSVFORMULA.BOOK_TYPE_CODE
40: AND ADJ.ASSET_ID = C_NEW_DEP_RSVFORMULA.ASSET_ID
41: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 483: FA_ADJUSTMENTS ADJ

479: ,'DR'
480: ,-ADJ.ADJUSTMENT_AMOUNT))
481: INTO L_TOT_REV_RSV
482: FROM
483: FA_ADJUSTMENTS ADJ
484: WHERE ADJ.ASSET_ID = C_OLD_REVAL_RSVFORMULA.ASSET_ID
485: AND ADJ.BOOK_TYPE_CODE = C_OLD_REVAL_RSVFORMULA.BOOK_TYPE_CODE
486: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
487: AND ADJ.ADJUSTMENT_TYPE = 'REVAL RESERVE';

Line 501: FA_ADJUSTMENTS ADJ

497: ,'DR'
498: ,-ADJ.ADJUSTMENT_AMOUNT)
499: INTO L_NEW_REV_RSV
500: FROM
501: FA_ADJUSTMENTS ADJ
502: WHERE ADJ.TRANSACTION_HEADER_ID = TH_ID
503: AND ADJ.ASSET_ID = C_OLD_REVAL_RSVFORMULA.ASSET_ID
504: AND ADJ.BOOK_TYPE_CODE = C_OLD_REVAL_RSVFORMULA.BOOK_TYPE_CODE
505: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 535: FA_ADJUSTMENTS ADJ

531: ,'DR'
532: ,ADJ.ADJUSTMENT_AMOUNT))
533: INTO L_TOT_DEP_RSV
534: FROM
535: FA_ADJUSTMENTS ADJ
536: WHERE ADJ.ASSET_ID = C_OLD_DEP_RSVFORMULA.ASSET_ID
537: AND ADJ.BOOK_TYPE_CODE = C_OLD_DEP_RSVFORMULA.BOOK_TYPE_CODE
538: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
539: AND ADJ.ADJUSTMENT_TYPE = 'RESERVE';

Line 553: FA_ADJUSTMENTS ADJ

549: ,'DR'
550: ,ADJ.ADJUSTMENT_AMOUNT)
551: INTO L_NEW_DEP_RSV
552: FROM
553: FA_ADJUSTMENTS ADJ
554: WHERE ADJ.TRANSACTION_HEADER_ID = TH_ID
555: AND ADJ.ASSET_ID = C_OLD_DEP_RSVFORMULA.ASSET_ID
556: AND ADJ.BOOK_TYPE_CODE = C_OLD_DEP_RSVFORMULA.BOOK_TYPE_CODE
557: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'