APPS.CSTPAPBR dependencies on MTL_FISCAL_CAT_ACCOUNTS

Line 1949: FROM mtl_fiscal_cat_accounts

1945: l_stmt_num := 15;
1946: BEGIN
1947: SELECT nvl(expense_account, -1)
1948: INTO l_exp_account
1949: FROM mtl_fiscal_cat_accounts
1950: WHERE legal_entity_id = i_ae_txn_rec.legal_entity_id
1951: AND cost_type_id = i_ae_txn_rec.cost_type_id
1952: AND cost_group_id = i_ae_txn_rec.cost_group_id
1953: AND category_id = i_ae_txn_rec.category_id;

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

2143:
2144: -- In R12, the Inventory Offset Account field has been removed from
2145: -- the Periodic Account Assignments form, so cst_org_cost_group_accounts.
2146: -- inventory_offset_account will not be set up. Instead, we will use the
2147: -- expense account from mtl_fiscal_cat_accounts as the offset account.
2148:
2149: l_acct_rec.account := l_exp_account;
2150:
2151: -- For same cost group transfers, regardless of whether the transfer is

Line 6035: from mtl_fiscal_cat_accounts

6031: -- ---------------------------------------
6032: l_stmt_num := 15;
6033: select count(legal_entity_id) /* Bug 4586534 */
6034: into l_acct_exist
6035: from mtl_fiscal_cat_accounts
6036: where legal_entity_id = i_ae_txn_rec.legal_entity_id
6037: and cost_type_id = i_ae_txn_rec.cost_type_id
6038: and cost_group_id = i_ae_txn_rec.cost_group_id
6039: and category_id = i_ae_txn_rec.category_id;

Line 6059: from mtl_fiscal_cat_accounts

6055: l_acct_rec.mat_ovhd_account,
6056: l_acct_rec.res_account,
6057: l_acct_rec.osp_account,
6058: l_acct_rec.ovhd_account
6059: from mtl_fiscal_cat_accounts
6060: where legal_entity_id = i_ae_txn_rec.legal_entity_id
6061: and cost_type_id = i_ae_txn_rec.cost_type_id
6062: and cost_group_id = i_ae_txn_rec.cost_group_id
6063: and category_id = i_ae_txn_rec.category_id;

Line 7484: from mtl_fiscal_cat_accounts

7480: l_stmt_num := 15;
7481:
7482: select count(legal_entity_id) /* changed for bug no. 4586534 */
7483: into l_acct_exist
7484: from mtl_fiscal_cat_accounts
7485: where legal_entity_id = i_ae_txn_rec.legal_entity_id
7486: and cost_type_id = i_ae_txn_rec.cost_type_id
7487: and cost_group_id = i_ae_txn_rec.cost_group_id
7488: and category_id = i_ae_txn_rec.category_id;

Line 7510: from mtl_fiscal_cat_accounts

7506: l_acct_rec.res_account,
7507: l_acct_rec.osp_account,
7508: l_acct_rec.ovhd_account,
7509: l_expense_account
7510: from mtl_fiscal_cat_accounts
7511: where legal_entity_id = i_ae_txn_rec.legal_entity_id
7512: and cost_type_id = i_ae_txn_rec.cost_type_id
7513: and cost_group_id = i_ae_txn_rec.cost_group_id
7514: and category_id = i_ae_txn_rec.category_id;

Line 9837: FROM mtl_fiscal_cat_accounts

9833: BEGIN
9834: l_stmt_num := 60;
9835: SELECT nvl(expense_account, -1)
9836: INTO l_mfa_exp_account
9837: FROM mtl_fiscal_cat_accounts
9838: WHERE legal_entity_id = i_ae_txn_rec.legal_entity_id
9839: AND cost_type_id = i_ae_txn_rec.cost_type_id
9840: AND cost_group_id = i_ae_txn_rec.cost_group_id
9841: AND category_id = i_ae_txn_rec.category_id;