APPS.FA_GENACCTS_PKG dependencies on FA_DISTRIBUTION_ACCOUNTS

Line 151: FROM fa_distribution_accounts da2,

147: dh.code_combination_id,
148: bks.bonus_rule,
149: bks.group_asset_id,
150: bks.tracking_method
151: FROM fa_distribution_accounts da2,
152: fa_additions_b ad,
153: fa_distribution_history dh,
154: fa_books bks
155: WHERE dh.date_ineffective is null

Line 826: FROM FA_DISTRIBUTION_ACCOUNTS

822: impair_reserve_account_ccid,
823: capital_adj_account_ccid, -- Bug 6666666
824: general_fund_account_ccid, -- Bug 6666666
825: reval_loss_account_ccid
826: FROM FA_DISTRIBUTION_ACCOUNTS
827: WHERE BOOK_TYPE_CODE = X_book_type_code
828: AND DISTRIBUTION_ID = X_distribution_id;
829:
830: BEGIN

Line 1867: -- into FA_DISTRIBUTION_ACCOUNTS

1863:
1864: close get_ccids;
1865:
1866: -- insert or update all the CCID's obtained for distribution
1867: -- into FA_DISTRIBUTION_ACCOUNTS
1868:
1869: h_user_id := fnd_global.user_id;
1870: h_login_id := fnd_global.login_id;
1871:

Line 1874: INSERT INTO FA_DISTRIBUTION_ACCOUNTS(

1870: h_login_id := fnd_global.login_id;
1871:
1872: if (not found) then
1873:
1874: INSERT INTO FA_DISTRIBUTION_ACCOUNTS(
1875: BOOK_TYPE_CODE,
1876: DISTRIBUTION_ID,
1877: ASSET_COST_ACCOUNT_CCID,
1878: ASSET_CLEARING_ACCOUNT_CCID,

Line 1947: UPDATE FA_DISTRIBUTION_ACCOUNTS

1943: h_capital_adj_ccid,
1944: h_general_fund_ccid,
1945: h_reval_loss_ccid);
1946: else
1947: UPDATE FA_DISTRIBUTION_ACCOUNTS
1948: SET ASSET_COST_ACCOUNT_CCID = h_cost_acct_ccid,
1949: ASSET_CLEARING_ACCOUNT_CCID = h_clearing_acct_ccid,
1950: DEPRN_EXPENSE_ACCOUNT_CCID = h_expense_acct_ccid,
1951: DEPRN_RESERVE_ACCOUNT_CCID = h_reserve_acct_ccid,