DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 2303: FROM mtl_intercompany_parameters MIP

2299: BEGIN
2300: /* Change the Query for the performance. Bug 4586534 */
2301: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
2302: INTO l_tprice_option
2303: FROM mtl_intercompany_parameters MIP
2304: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
2305: AND (select count(1)
2306: from hr_organization_information HOI
2307: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id,

Line 4305: FROM mtl_intercompany_parameters MIP

4301: BEGIN
4302: /* Change the Query for the performance. Bug 4586534 */
4303: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
4304: INTO l_tprice_option
4305: FROM mtl_intercompany_parameters MIP
4306: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
4307: AND ( select count(1)
4308: FROM hr_organization_information HOI
4309: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id, 21,