APPS.JE_JEHUFAMS_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 343: FA_DEPRN_DETAIL DD

339: FROM
340: FA_DISTRIBUTION_HISTORY DH,
341: FA_CATEGORY_BOOKS CB,
342: FA_ADDITIONS AD,
343: FA_DEPRN_DETAIL DD
344: WHERE NOT EXISTS (
345: SELECT
346: BR.ASSET_ID
347: FROM

Line 404: FA_DEPRN_DETAIL DD,

400: FA_LOOKUPS RT,
401: FA_CATEGORY_BOOKS CB,
402: FA_DISTRIBUTION_HISTORY DH,
403: FA_ASSET_HISTORY AH,
404: FA_DEPRN_DETAIL DD,
405: FA_DEPRN_PERIODS DP
406: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
407: AND AH.ASSET_ID = DH.ASSET_ID
408: AND AH.ASSET_TYPE = 'CAPITALIZED'

Line 591: FA_DEPRN_DETAIL DD,

587: FROM
588: FA_BOOKS BK,
589: FA_CATEGORY_BOOKS CB,
590: FA_ASSET_HISTORY AH,
591: FA_DEPRN_DETAIL DD,
592: FA_DISTRIBUTION_HISTORY DH
593: WHERE DH.BOOK_TYPE_CODE || '' = CP_DISTRIBUTION_SOURCE_BOOK
594: AND DECODE(DD.DEPRN_SOURCE_CODE
595: ,'D'

Line 612: FA_DEPRN_DETAIL SUB_DD

608: AND DD.PERIOD_COUNTER = (
609: SELECT
610: MAX(SUB_DD.PERIOD_COUNTER)
611: FROM
612: FA_DEPRN_DETAIL SUB_DD
613: WHERE SUB_DD.BOOK_TYPE_CODE = P_BOOK
614: AND SUB_DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID + 0
615: AND SUB_DD.PERIOD_COUNTER <= CP_PERIOD_PC )
616: AND AH.ASSET_ID = DH.ASSET_ID + 0