APPS.JE_JEHUFAMD_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 583: FA_DEPRN_DETAIL DD,

579: FROM
580: FA_BOOKS BK,
581: FA_CATEGORY_BOOKS CB,
582: FA_ASSET_HISTORY AH,
583: FA_DEPRN_DETAIL DD,
584: FA_DISTRIBUTION_HISTORY DH
585: WHERE DH.BOOK_TYPE_CODE || '' = CP_DISTRIBUTION_SOURCE_BOOK
586: AND DECODE(DD.DEPRN_SOURCE_CODE
587: ,'D'

Line 604: FA_DEPRN_DETAIL SUB_DD

600: AND DD.PERIOD_COUNTER = (
601: SELECT
602: MAX(SUB_DD.PERIOD_COUNTER)
603: FROM
604: FA_DEPRN_DETAIL SUB_DD
605: WHERE SUB_DD.BOOK_TYPE_CODE = P_BOOK
606: AND SUB_DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID + 0
607: AND SUB_DD.PERIOD_COUNTER <= CP_PERIOD_PC )
608: AND AH.ASSET_ID = DH.ASSET_ID + 0