APPS.CSTPAPBR dependencies on MTL_PAC_TXN_COST_DETAILS

Line 2316: FROM mtl_pac_txn_cost_details

2312: l_stmt_num := 80;
2313:
2314: SELECT sum(nvl(transaction_cost,0))
2315: INTO l_mptcd_cost
2316: FROM mtl_pac_txn_cost_details
2317: WHERE transaction_id = i_ae_txn_rec.transaction_id
2318: AND pac_period_id = i_ae_txn_rec.accounting_period_id
2319: AND cost_group_id = i_ae_txn_rec.cost_group_id;
2320:

Line 3202: FROM mtl_pac_txn_cost_details

3198: l_stmt_num := 224;
3199:
3200: SELECT sum(nvl(transaction_cost,0))
3201: INTO l_mptcd_cost
3202: FROM mtl_pac_txn_cost_details
3203: WHERE transaction_id = i_ae_txn_rec.transaction_id
3204: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3205: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3206:

Line 4284: FROM mtl_pac_txn_cost_details

4280: l_stmt_num := 412;
4281:
4282: SELECT sum(nvl(transaction_cost,0))
4283: INTO l_mptcd_cost
4284: FROM mtl_pac_txn_cost_details
4285: WHERE transaction_id = i_ae_txn_rec.transaction_id
4286: AND pac_period_id = i_ae_txn_rec.accounting_period_id
4287: AND cost_group_id = i_ae_txn_rec.cost_group_id;
4288:

Line 4538: FROM mtl_pac_txn_cost_details

4534: l_stmt_num := 435;
4535:
4536: SELECT sum(nvl(transaction_cost,0))
4537: INTO l_mptcd_cost
4538: FROM mtl_pac_txn_cost_details
4539: WHERE transaction_id = i_ae_txn_rec.transaction_id
4540: AND pac_period_id = i_ae_txn_rec.accounting_period_id
4541: AND cost_group_id = i_ae_txn_rec.cost_group_id;
4542:

Line 5285: FROM mtl_pac_txn_cost_details

5281:
5282:
5283: SELECT sum(nvl(transaction_cost,0))
5284: INTO l_mptcd_cost
5285: FROM mtl_pac_txn_cost_details
5286: WHERE transaction_id = i_ae_txn_rec.transaction_id
5287: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5288: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5289:

Line 5820: from mtl_pac_txn_cost_details mptcd

5816: -- -----------------------------------------------
5817: l_stmt_num := 30;
5818: select count (1)
5819: into l_value_change_flag
5820: from mtl_pac_txn_cost_details mptcd
5821: where mptcd.transaction_id = i_ae_txn_rec.transaction_id
5822: and mptcd.pac_period_id = i_ae_txn_rec.accounting_period_id
5823: and mptcd.cost_group_id = i_ae_txn_rec.cost_group_id
5824: and mptcd.value_change is not null