DBA Data[Home] [Help]

APPS.FA_BALREP_PKG dependencies on FA_DEPRN_SUMMARY

Line 1964: FROM fa_deprn_summary_mrc_v dd,

1960: */
1961: 'BEGIN',
1962: dd.deprn_reserve,
1963: h_request_id
1964: FROM fa_deprn_summary_mrc_v dd,
1965: fa_group_asset_rules gar,
1966: fa_group_asset_default gad
1967: WHERE dd.book_type_code = book
1968: AND dd.asset_id = gar.group_asset_id

Line 2003: FROM fa_deprn_summary dd,

1999: */
2000: 'BEGIN',
2001: dd.deprn_reserve,
2002: h_request_id
2003: FROM fa_deprn_summary dd,
2004: fa_group_asset_rules gar,
2005: fa_group_asset_default gad
2006: WHERE dd.book_type_code = book
2007: AND dd.asset_id = gar.group_asset_id

Line 2314: FROM fa_deprn_summary_mrc_v dd,

2310: Begin_or_End),*/
2311: 'END',
2312: dd.deprn_reserve,
2313: h_request_id
2314: FROM fa_deprn_summary_mrc_v dd,
2315: fa_group_asset_rules gar,
2316: fa_group_asset_default gad
2317: WHERE dd.book_type_code = book
2318: AND dd.asset_id = gar.group_asset_id

Line 2352: FROM fa_deprn_summary dd,

2348: Begin_or_End),*/
2349: 'END',
2350: dd.deprn_reserve,
2351: h_request_id
2352: FROM fa_deprn_summary dd,
2353: fa_group_asset_rules gar,
2354: fa_group_asset_default gad
2355: WHERE dd.book_type_code = book
2356: AND dd.asset_id = gar.group_asset_id

Line 2591: FROM fa_deprn_summary_mrc_v dd,

2587: NULL,
2588: 'DEPRECIATION',
2589: SUM(dd.deprn_amount),
2590: h_request_id
2591: FROM fa_deprn_summary_mrc_v dd,
2592: fa_group_asset_rules gar,
2593: fa_group_asset_default gad
2594: WHERE dd.book_type_code = book
2595: AND dd.asset_id = gar.group_asset_id

Line 2622: FROM fa_deprn_summary dd,

2618: NULL,
2619: 'DEPRECIATION',
2620: SUM(dd.deprn_amount),
2621: h_request_id
2622: FROM fa_deprn_summary dd,
2623: fa_group_asset_rules gar,
2624: fa_group_asset_default gad
2625: WHERE dd.book_type_code = book
2626: AND dd.asset_id = gar.group_asset_id