APPS.FA_GENACCTS_PKG dependencies on FA_DISTRIBUTION_ACCOUNTS

Line 141: FROM fa_distribution_accounts da2,

137: dh.code_combination_id,
138: bks.bonus_rule,
139: bks.group_asset_id,
140: bks.tracking_method
141: FROM fa_distribution_accounts da2,
142: fa_additions_b ad,
143: fa_distribution_history dh,
144: fa_books bks
145: WHERE dh.date_ineffective is null

Line 793: FROM FA_DISTRIBUTION_ACCOUNTS

789: reval_amort_account_ccid,
790: reval_rsv_account_ccid,
791: bonus_exp_account_ccid,
792: bonus_rsv_account_ccid
793: FROM FA_DISTRIBUTION_ACCOUNTS
794: WHERE BOOK_TYPE_CODE = X_book_type_code
795: AND DISTRIBUTION_ID = X_distribution_id;
796:
797: BEGIN

Line 1675: -- into FA_DISTRIBUTION_ACCOUNTS

1671:
1672: close get_ccids;
1673:
1674: -- insert or update all the CCID's obtained for distribution
1675: -- into FA_DISTRIBUTION_ACCOUNTS
1676:
1677: h_user_id := fnd_global.user_id;
1678: h_login_id := fnd_global.login_id;
1679:

Line 1682: INSERT INTO FA_DISTRIBUTION_ACCOUNTS(

1678: h_login_id := fnd_global.login_id;
1679:
1680: if (not found) then
1681:
1682: INSERT INTO FA_DISTRIBUTION_ACCOUNTS(
1683: BOOK_TYPE_CODE,
1684: DISTRIBUTION_ID,
1685: ASSET_COST_ACCOUNT_CCID,
1686: ASSET_CLEARING_ACCOUNT_CCID,

Line 1746: UPDATE FA_DISTRIBUTION_ACCOUNTS

1742: h_bonus_exp_ccid,
1743: h_bonus_rsv_ccid
1744: );
1745: else
1746: UPDATE FA_DISTRIBUTION_ACCOUNTS
1747: SET ASSET_COST_ACCOUNT_CCID = h_cost_acct_ccid,
1748: ASSET_CLEARING_ACCOUNT_CCID = h_clearing_acct_ccid,
1749: DEPRN_EXPENSE_ACCOUNT_CCID = h_expense_acct_ccid,
1750: DEPRN_RESERVE_ACCOUNT_CCID = h_reserve_acct_ccid,