DBA Data[Home] [Help]

APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_DEPRN_SUMMARY

Line 1885: from fa_deprn_summary ds1,

1881:
1882: --* Cursor to populate the member level amounts
1883: cursor MEM_EXP_RESERVE is
1884: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
1885: from fa_deprn_summary ds1,
1886: fa_deprn_periods dp1
1887: where ds1.book_type_code = h_book_type_code
1888: and ds1.asset_id = h_member_asset_id
1889: and dp1.book_type_code = ds1.book_type_Code

Line 1893: from fa_deprn_summary ds2

1889: and dp1.book_type_code = ds1.book_type_Code
1890: and dp1.period_counter = ds1.period_counter
1891: and ds1.period_counter =
1892: (select max(period_counter)
1893: from fa_deprn_summary ds2
1894: where ds2.book_type_code = h_book_type_code
1895: and ds2.asset_id = h_member_asset_id
1896: and period_counter <= h_period_counter);
1897:

Line 1909: from fa_deprn_summary ds2

1905: and dp1.period_counter = ds1.period_counter
1906: and dp1.set_of_books_id = h_set_of_books_id
1907: and ds1.period_counter =
1908: (select max(period_counter)
1909: from fa_deprn_summary ds2
1910: where ds2.book_type_code = h_book_type_code
1911: and ds2.asset_id = h_member_asset_id
1912: and period_counter <= h_period_counter)
1913: and ds1.set_of_books_id = h_set_of_books_id;