DBA Data[Home] [Help]

APPS.FA_BALREP_PKG dependencies on FA_GROUP_ASSET_RULES

Line 1965: fa_group_asset_rules gar,

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
1969: AND gar.book_type_code = dd.book_type_code

Line 2004: fa_group_asset_rules gar,

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
2008: AND dd.asset_id BETWEEN start_range AND end_range --Anuj

Line 2315: fa_group_asset_rules gar,

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
2319: AND dd.asset_id BETWEEN start_range AND end_range --Anuj

Line 2353: fa_group_asset_rules gar,

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
2357: AND dd.asset_id BETWEEN start_range AND end_range --Anuj

Line 2592: fa_group_asset_rules gar,

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
2596: AND dd.asset_id BETWEEN start_range AND end_range --Anuj

Line 2623: fa_group_asset_rules gar,

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
2627: AND dd.asset_id BETWEEN start_range AND end_range --Anuj