DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 2021: FROM mtl_intercompany_parameters MIP

2017: BEGIN
2018: /* Change the Query for the performance. Bug 4586534 */
2019: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
2020: INTO l_tprice_option
2021: FROM mtl_intercompany_parameters MIP
2022: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
2023: AND (select count(1)
2024: from hr_organization_information HOI
2025: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id,

Line 4023: FROM mtl_intercompany_parameters MIP

4019: BEGIN
4020: /* Change the Query for the performance. Bug 4586534 */
4021: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
4022: INTO l_tprice_option
4023: FROM mtl_intercompany_parameters MIP
4024: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
4025: AND ( select count(1)
4026: FROM hr_organization_information HOI
4027: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id, 21,