APPS.FA_ASSET_SUMM_RPT_PKG dependencies on FA_DEPRN_SUMMARY

Line 508: FROM fa_deprn_summary fds

504: BEGIN
505: BEGIN
506: SELECT fdd.deprn_reserve
507: INTO ln_amount
508: FROM fa_deprn_summary fds
509: ,fa_deprn_detail fdd
510: ,fa_distribution_history fdh
511: WHERE fds.book_type_code = fdd.book_type_code
512: AND fds.asset_id = fdd.asset_id

Line 524: FROM fa_deprn_summary fds1

520: AND fdh.code_combination_id = p_ccid_in
521: AND fdh.location_id = p_location_id_in
522: AND fds.period_counter = (
523: SELECT MAX(fds1.period_counter)
524: FROM fa_deprn_summary fds1
525: ,fa_deprn_detail fdd1
526: ,fa_distribution_history fdh1
527: WHERE fds1.book_type_code = fdd1.book_type_code
528: AND fds1.asset_id = fdd1.asset_id

Line 544: FROM fa_deprn_summary fds

540: WHEN NO_DATA_FOUND THEN
541: BEGIN
542: SELECT fdd.deprn_reserve
543: INTO ln_amount
544: FROM fa_deprn_summary fds
545: ,fa_deprn_detail fdd
546: ,fa_distribution_history fdh
547: ,fa_books fb
548: WHERE fds.book_type_code = fdd.book_type_code

Line 564: FROM fa_deprn_summary fds1

560: AND fb.date_ineffective IS NULL
561: AND fb.period_counter_life_complete IS NOT NULL
562: AND fds.period_counter = (
563: SELECT MAX(fds1.period_counter)
564: FROM fa_deprn_summary fds1
565: ,fa_deprn_detail fdd1
566: ,fa_distribution_history fdh1
567: WHERE fds1.book_type_code = fdd1.book_type_code
568: AND fds1.asset_id = fdd1.asset_id

Line 587: FROM fa_deprn_summary fds

583: END;
584: WHEN TOO_MANY_ROWS THEN
585: SELECT MAX(fdd.deprn_reserve)
586: INTO ln_amount
587: FROM fa_deprn_summary fds
588: ,fa_deprn_detail fdd
589: ,fa_distribution_history fdh
590: WHERE fds.book_type_code = fdd.book_type_code
591: AND fds.asset_id = fdd.asset_id

Line 603: FROM fa_deprn_summary fds1

599: AND fdh.code_combination_id = p_ccid_in
600: AND fdh.location_id = p_location_id_in
601: AND fds.period_counter = (
602: SELECT MAX(fds1.period_counter)
603: FROM fa_deprn_summary fds1
604: ,fa_deprn_detail fdd1
605: ,fa_distribution_history fdh1
606: WHERE fds1.book_type_code = fdd1.book_type_code
607: AND fds1.asset_id = fdd1.asset_id

Line 642: FROM fa_deprn_summary fds

638: BEGIN
639: BEGIN
640: SELECT SUM(DECODE(fdd.deprn_source_code,'B',fdd.deprn_reserve,fdd.deprn_amount))
641: INTO ln_amount
642: FROM fa_deprn_summary fds
643: ,fa_deprn_detail fdd
644: ,fa_distribution_history fdh
645: WHERE fds.book_type_code = fdd.book_type_code
646: AND fds.asset_id = fdd.asset_id

Line 684: ,fa_deprn_summary fds

680: BEGIN
681: SELECT fdd.deprn_reserve
682: INTO ln_amount
683: FROM fa_books fb
684: ,fa_deprn_summary fds
685: ,fa_deprn_detail fdd
686: ,fa_distribution_history fdh
687: WHERE fb.book_type_code = P_BOOK_NAME
688: AND fb.date_ineffective IS NULL