APPS.CSTPAPBR dependencies on MTL_FISCAL_CAT_ACCOUNTS

Line 1729: FROM mtl_fiscal_cat_accounts

1725: l_stmt_num := 15;
1726: BEGIN
1727: SELECT nvl(expense_account, -1)
1728: INTO l_exp_account
1729: FROM mtl_fiscal_cat_accounts
1730: WHERE legal_entity_id = i_ae_txn_rec.legal_entity_id
1731: AND cost_type_id = i_ae_txn_rec.cost_type_id
1732: AND cost_group_id = i_ae_txn_rec.cost_group_id
1733: AND category_id = i_ae_txn_rec.category_id;

Line 1865: -- expense account from mtl_fiscal_cat_accounts as the offset account.

1861:
1862: -- In R12, the Inventory Offset Account field has been removed from
1863: -- the Periodic Account Assignments form, so cst_org_cost_group_accounts.
1864: -- inventory_offset_account will not be set up. Instead, we will use the
1865: -- expense account from mtl_fiscal_cat_accounts as the offset account.
1866:
1867: l_acct_rec.account := l_exp_account;
1868:
1869: -- For same cost group transfers, regardless of whether the transfer is

Line 5753: from mtl_fiscal_cat_accounts

5749: -- ---------------------------------------
5750: l_stmt_num := 15;
5751: select count(legal_entity_id) /* Bug 4586534 */
5752: into l_acct_exist
5753: from mtl_fiscal_cat_accounts
5754: where legal_entity_id = i_ae_txn_rec.legal_entity_id
5755: and cost_type_id = i_ae_txn_rec.cost_type_id
5756: and cost_group_id = i_ae_txn_rec.cost_group_id
5757: and category_id = i_ae_txn_rec.category_id;

Line 5777: from mtl_fiscal_cat_accounts

5773: l_acct_rec.mat_ovhd_account,
5774: l_acct_rec.res_account,
5775: l_acct_rec.osp_account,
5776: l_acct_rec.ovhd_account
5777: from mtl_fiscal_cat_accounts
5778: where legal_entity_id = i_ae_txn_rec.legal_entity_id
5779: and cost_type_id = i_ae_txn_rec.cost_type_id
5780: and cost_group_id = i_ae_txn_rec.cost_group_id
5781: and category_id = i_ae_txn_rec.category_id;

Line 7110: from mtl_fiscal_cat_accounts

7106: l_stmt_num := 15;
7107:
7108: select count(legal_entity_id) /* changed for bug no. 4586534 */
7109: into l_acct_exist
7110: from mtl_fiscal_cat_accounts
7111: where legal_entity_id = i_ae_txn_rec.legal_entity_id
7112: and cost_type_id = i_ae_txn_rec.cost_type_id
7113: and cost_group_id = i_ae_txn_rec.cost_group_id
7114: and category_id = i_ae_txn_rec.category_id;

Line 7136: from mtl_fiscal_cat_accounts

7132: l_acct_rec.res_account,
7133: l_acct_rec.osp_account,
7134: l_acct_rec.ovhd_account,
7135: l_expense_account
7136: from mtl_fiscal_cat_accounts
7137: where legal_entity_id = i_ae_txn_rec.legal_entity_id
7138: and cost_type_id = i_ae_txn_rec.cost_type_id
7139: and cost_group_id = i_ae_txn_rec.cost_group_id
7140: and category_id = i_ae_txn_rec.category_id;

Line 9391: FROM mtl_fiscal_cat_accounts

9387: BEGIN
9388: l_stmt_num := 60;
9389: SELECT nvl(expense_account, -1)
9390: INTO l_mfa_exp_account
9391: FROM mtl_fiscal_cat_accounts
9392: WHERE legal_entity_id = i_ae_txn_rec.legal_entity_id
9393: AND cost_type_id = i_ae_txn_rec.cost_type_id
9394: AND cost_group_id = i_ae_txn_rec.cost_group_id
9395: AND category_id = i_ae_txn_rec.category_id;