DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 537: FROM fa_deprn_summary_mrc_v a

533:
534: BEGIN
535: SELECT NVL(a.deprn_reserve - a.ytd_deprn,0)
536: INTO p_accum_depr_begin_period
537: FROM fa_deprn_summary_mrc_v a
538: WHERE a.book_type_code = p_hist_book_type_code
539: AND a.asset_id = p_asset_id
540: AND a.period_counter between p_period_counter_from AND p_period_counter_to
541: AND a.deprn_source_code = 'BOOKS';

Line 553: FROM fa_deprn_summary_mrc_v a

549: IF p_accum_depr_begin_period = 0 THEN
550: BEGIN
551: SELECT NVL(a.deprn_reserve,0)
552: INTO p_accum_depr_begin_period
553: FROM fa_deprn_summary_mrc_v a
554: WHERE a.book_type_code = p_hist_book_type_code
555: AND a.asset_id = p_asset_id
556: AND a.period_counter in (SELECT max(b.period_counter)
557: FROM fa_deprn_summary_mrc_v b

Line 557: FROM fa_deprn_summary_mrc_v b

553: FROM fa_deprn_summary_mrc_v a
554: WHERE a.book_type_code = p_hist_book_type_code
555: AND a.asset_id = p_asset_id
556: AND a.period_counter in (SELECT max(b.period_counter)
557: FROM fa_deprn_summary_mrc_v b
558: WHERE b.book_type_code = p_hist_book_type_code
559: AND b.asset_id = p_asset_id
560: AND b.period_counter <= p_period_counter_from - 1);
561: EXCEPTION

Line 628: FROM fa_deprn_summary_mrc_v a

624: --
625: BEGIN
626: SELECT NVL(a.deprn_reserve,0)
627: INTO p_hist_accum_depr_end_period
628: FROM fa_deprn_summary_mrc_v a
629: WHERE a.book_type_code = p_hist_book_type_code
630: AND a.asset_id = p_asset_id
631: AND a.period_counter in (SELECT max(b.period_counter)
632: FROM fa_deprn_summary_mrc_v b

Line 632: FROM fa_deprn_summary_mrc_v b

628: FROM fa_deprn_summary_mrc_v a
629: WHERE a.book_type_code = p_hist_book_type_code
630: AND a.asset_id = p_asset_id
631: AND a.period_counter in (SELECT max(b.period_counter)
632: FROM fa_deprn_summary_mrc_v b
633: WHERE b.book_type_code = p_hist_book_type_code
634: AND b.asset_id = p_asset_id
635: AND b.period_counter <= p_period_counter_to);
636: EXCEPTION

Line 644: FROM fa_deprn_summary_mrc_v a

640:
641: BEGIN
642: SELECT NVL(a.deprn_reserve,0)
643: INTO p_adj_accum_depr_end_period
644: FROM fa_deprn_summary_mrc_v a
645: WHERE a.book_type_code = p_adj_book_type_code
646: AND a.asset_id = p_asset_id
647: AND a.period_counter in (SELECT max(b.period_counter)
648: FROM fa_deprn_summary_mrc_v b

Line 648: FROM fa_deprn_summary_mrc_v b

644: FROM fa_deprn_summary_mrc_v a
645: WHERE a.book_type_code = p_adj_book_type_code
646: AND a.asset_id = p_asset_id
647: AND a.period_counter in (SELECT max(b.period_counter)
648: FROM fa_deprn_summary_mrc_v b
649: WHERE b.book_type_code = p_adj_book_type_code
650: AND b.asset_id = p_asset_id
651: AND b.period_counter <= p_period_counter_to);
652: EXCEPTION

Line 665: FROM fa_deprn_summary_mrc_v a

661: p_depr_rpt_period := 0;
662: BEGIN
663: SELECT NVL(a.ytd_deprn,0)
664: INTO l_depr_rpt_period
665: FROM fa_deprn_summary_mrc_v a
666: WHERE a.book_type_code = p_hist_book_type_code
667: AND a.asset_id = p_asset_id
668: AND a.deprn_source_code = 'BOOKS'
669: AND a.period_counter between p_period_counter_from and p_period_counter_to;

Line 681: FROM fa_deprn_summary_mrc_v a

677:
678: BEGIN
679: SELECT NVL(SUM(NVL(a.deprn_amount,0)),0)
680: INTO p_depr_rpt_period
681: FROM fa_deprn_summary_mrc_v a
682: WHERE a.book_type_code = p_hist_book_type_code
683: AND a.asset_id = p_asset_id
684: AND a.deprn_source_code = 'DEPRN'
685: AND a.period_counter between p_period_counter_from and p_period_counter_to;