APPS.FA_ASSET_SUMM_RPT_PKG dependencies on FA_DEPRN_SUMMARY

Line 528: FROM fa_deprn_summary fds

524: BEGIN
525: BEGIN
526: SELECT NVL(fdd.deprn_reserve,0)
527: INTO ln_amount
528: FROM fa_deprn_summary fds
529: ,fa_deprn_detail fdd
530: ,fa_distribution_history fdh
531: WHERE fds.book_type_code = fdd.book_type_code
532: AND fds.asset_id = fdd.asset_id

Line 544: FROM fa_deprn_summary fds1

540: AND fdh.code_combination_id = p_ccid_in
541: AND fdh.location_id = p_location_id_in
542: AND fds.period_counter = (
543: SELECT MAX(fds1.period_counter)
544: FROM fa_deprn_summary fds1
545: ,fa_deprn_detail fdd1
546: ,fa_distribution_history fdh1
547: WHERE fds1.book_type_code = fdd1.book_type_code
548: AND fds1.asset_id = fdd1.asset_id

Line 564: FROM fa_deprn_summary fds

560: WHEN NO_DATA_FOUND THEN
561: BEGIN
562: SELECT fdd.deprn_reserve
563: INTO ln_amount
564: FROM fa_deprn_summary fds
565: ,fa_deprn_detail fdd
566: ,fa_distribution_history fdh
567: ,fa_books fb
568: WHERE fds.book_type_code = fdd.book_type_code

Line 584: FROM fa_deprn_summary fds1

580: AND fb.date_ineffective IS NULL
581: AND fb.period_counter_life_complete IS NOT NULL
582: AND fds.period_counter = (
583: SELECT MAX(fds1.period_counter)
584: FROM fa_deprn_summary fds1
585: ,fa_deprn_detail fdd1
586: ,fa_distribution_history fdh1
587: WHERE fds1.book_type_code = fdd1.book_type_code
588: AND fds1.asset_id = fdd1.asset_id

Line 607: FROM fa_deprn_summary fds

603: END;
604: WHEN TOO_MANY_ROWS THEN
605: SELECT NVL(MAX(fdd.deprn_reserve),0)
606: INTO ln_amount
607: FROM fa_deprn_summary fds
608: ,fa_deprn_detail fdd
609: ,fa_distribution_history fdh
610: WHERE fds.book_type_code = fdd.book_type_code
611: AND fds.asset_id = fdd.asset_id

Line 623: FROM fa_deprn_summary fds1

619: AND fdh.code_combination_id = p_ccid_in
620: AND fdh.location_id = p_location_id_in
621: AND fds.period_counter = (
622: SELECT MAX(fds1.period_counter)
623: FROM fa_deprn_summary fds1
624: ,fa_deprn_detail fdd1
625: ,fa_distribution_history fdh1
626: WHERE fds1.book_type_code = fdd1.book_type_code
627: AND fds1.asset_id = fdd1.asset_id

Line 663: FROM fa_deprn_summary fds

659: BEGIN
660: BEGIN
661: SELECT NVL(SUM(DECODE(fdd.deprn_source_code,'B',fdd.deprn_reserve,fdd.deprn_amount)),0)
662: INTO ln_amount
663: FROM fa_deprn_summary fds
664: ,fa_deprn_detail fdd
665: ,fa_distribution_history fdh
666: WHERE fds.book_type_code = fdd.book_type_code
667: AND fds.asset_id = fdd.asset_id

Line 706: ,fa_deprn_summary fds

702: BEGIN
703: SELECT NVL(fdd.deprn_reserve,0)
704: INTO ln_amount
705: FROM fa_books fb
706: ,fa_deprn_summary fds
707: ,fa_deprn_detail fdd
708: ,fa_distribution_history fdh
709: WHERE fb.book_type_code = P_BOOK_NAME
710: AND fb.date_ineffective IS NULL