APPS.FA_RX_GROUP dependencies on FA_DEPRN_SUMMARY

Line 376: fa_deprn_summary ds_pre,

372: fa_books bkm,
373: (SELECT bk_pre.asset_id,
374: bk_pre.group_asset_id
375: FROM fa_books bk_pre,
376: fa_deprn_summary ds_pre,
377: fa_deprn_periods dp_pre
378: WHERE bk_pre.book_type_code = p_book_type_code
379: AND dp_pre.book_type_code = bk_pre.book_type_code
380: AND dp_pre.period_counter + 1 = l_info_rec.min_period_counter

Line 387: FROM fa_deprn_summary ds3

383: AND ds_pre.book_type_code = bk_pre.book_type_code
384: AND ds_pre.asset_id = bk_pre.asset_id
385: AND ds_pre.period_counter = (
386: SELECT MAX(ds3.period_counter)
387: FROM fa_deprn_summary ds3
388: WHERE ds_pre.book_type_code = ds3.book_type_code
389: AND ds_pre.asset_id = ds3.asset_id
390: AND ds3.period_counter < l_info_rec.min_period_counter
391: )

Line 757: -- Subquery is to get fa_books and fa_deprn_summary,

753: x_sql_stmt OUT NOCOPY VARCHAR2)
754: IS
755: BEGIN
756:
757: -- Subquery is to get fa_books and fa_deprn_summary,
758: -- which are used to calculate beginning NBV.
759: -- Subquery doesn't necessarily get the previous year info.
760: -- If there was no depreciation calculation in the previous year,
761: -- subquery gets the max period counter prior to the fiscal year.

Line 770: fa_deprn_summary ds,

766: fa_categories_b cat,
767: fa_deprn_basis_rules br,
768: fa_methods met,
769: fa_deprn_periods dp,
770: fa_deprn_summary ds,
771: ( SELECT bk_pre.asset_id,
772: bk_pre.group_asset_id,
773: bk_pre.cost,
774: bk_pre.cip_cost,

Line 777: fa_deprn_summary ds_pre,

773: bk_pre.cost,
774: bk_pre.cip_cost,
775: ds_pre.deprn_reserve
776: FROM fa_books bk_pre,
777: fa_deprn_summary ds_pre,
778: fa_deprn_periods dp_pre,
779: fa_additions ad_pre
780: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
781: AND dp_pre.book_type_code = bk_pre.book_type_code

Line 789: FROM fa_deprn_summary ds3

785: AND ds_pre.book_type_code = bk_pre.book_type_code
786: AND ds_pre.asset_id = bk_pre.asset_id
787: AND ds_pre.period_counter = (
788: SELECT MAX(ds3.period_counter)
789: FROM fa_deprn_summary ds3
790: WHERE ds_pre.book_type_code = ds3.book_type_code
791: AND ds_pre.asset_id = ds3.asset_id
792: AND ds3.period_counter < ' || p_info_rec.min_period_counter || '
793: )

Line 833: -- This also gets fa_deprn_summary no matter what.

829:
830: -- This where clause ges fa_books, which corresponds to
831: -- the last depreciated period in the fiscal year.
832:
833: -- This also gets fa_deprn_summary no matter what.
834: -- There is at least deprn_source_code = 'BOOKS' row for every asset.
835: -- fa_deprn_summary.period_counter will be the max period
836: -- including the current fiscal year.
837:

Line 835: -- fa_deprn_summary.period_counter will be the max period

831: -- the last depreciated period in the fiscal year.
832:
833: -- This also gets fa_deprn_summary no matter what.
834: -- There is at least deprn_source_code = 'BOOKS' row for every asset.
835: -- fa_deprn_summary.period_counter will be the max period
836: -- including the current fiscal year.
837:
838: x_sql_stmt :=
839: 'WHERE bk.book_type_code = ''' || p_info_rec.book_type_code || '''

Line 855: FROM fa_deprn_summary ds2

851: AND ds.book_type_code = bk.book_type_code
852: AND ds.asset_id = bk.asset_id
853: AND ds.period_counter = (
854: SELECT MAX(ds2.period_counter)
855: FROM fa_deprn_summary ds2
856: WHERE ds2.book_type_code = ds.book_type_code
857: AND ds2.asset_id = ds.asset_id
858: AND ds2.period_counter <= ' || p_info_rec.max_period_counter || ' )
859: AND bk.asset_id = prev.asset_id (+)';