APPS.FA_RX_GROUP dependencies on FA_ADDITIONS

Line 680: FROM fa_books bk, fa_additions ad

676: AND NVL(l_group_rec.rule_name, ' ') = FA_RXGA_POSITIVE_REDUCTION THEN
677:
678: SELECT COUNT(*)
679: INTO l_non_cip_num
680: FROM fa_books bk, fa_additions ad
681: WHERE bk.book_type_code = p_book_type_code
682: AND bk.group_asset_id = l_group_rec.asset_id
683: AND ad.asset_type <> 'CIP'
684: AND bk.asset_id = ad.asset_id;

Line 970: fa_additions ad,

966: -- If there was no depreciation calculation in the previous year,
967: -- subquery gets the max period counter prior to the fiscal year.
968: if(P_MRCSOBTYPE <> 'R') then -- MRC
969: x_sql_stmt := ' FROM
970: fa_additions ad,
971: fa_books bk,
972: fa_categories_b cat,
973: fa_deprn_basis_rules br,
974: fa_methods met,

Line 985: fa_additions ad_pre

981: ds_pre.deprn_reserve
982: FROM fa_books bk_pre,
983: fa_deprn_summary ds_pre,
984: fa_deprn_periods dp_pre,
985: fa_additions ad_pre
986: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
987: AND dp_pre.book_type_code = bk_pre.book_type_code
988: AND dp_pre.period_counter + 1 = ' || p_info_rec.min_period_counter || '
989: AND dp_pre.period_close_date BETWEEN bk_pre.date_effective

Line 1004: fa_additions ad,

1000: AND ad_pre.asset_id = bk_pre.asset_id ';
1001: -- MRC
1002: else
1003: x_sql_stmt := ' FROM
1004: fa_additions ad,
1005: fa_mc_books bk,
1006: fa_categories_b cat,
1007: fa_deprn_basis_rules br,
1008: fa_methods met,

Line 1019: fa_additions ad_pre

1015: ds_pre.deprn_reserve
1016: FROM fa_mc_books bk_pre,
1017: fa_mc_deprn_summary ds_pre,
1018: fa_mc_deprn_periods dp_pre,
1019: fa_additions ad_pre
1020: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
1021: AND dp_pre.book_type_code = bk_pre.book_type_code
1022: AND dp_pre.period_counter + 1 = ' || p_info_rec.min_period_counter || '
1023: AND dp_pre.period_close_date BETWEEN bk_pre.date_effective