APPS.CSTPAPBR dependencies on HR_ORGANIZATION_INFORMATION

Line 2024: from hr_organization_information HOI

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,
2026: 21, i_ae_txn_rec.organization_id,
2027: i_ae_txn_rec.xfer_organization_id)
2028: AND HOI.org_information_context = 'Accounting Information'

Line 2032: from hr_organization_information HOI2

2028: AND HOI.org_information_context = 'Accounting Information'
2029: AND MIP.ship_organization_id = to_number(HOI.org_information3)
2030: AND ROWNUM < 2) >0
2031: AND ( select count(1)
2032: from hr_organization_information HOI2
2033: where HOI2.organization_id = decode(i_ae_txn_rec.txn_action_id,
2034: 21, i_ae_txn_rec.xfer_organization_id,
2035: i_ae_txn_rec.organization_id)
2036: AND HOI2.org_information_context = 'Accounting Information'

Line 4026: FROM hr_organization_information HOI

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,
4028: i_ae_txn_rec.organization_id,
4029: i_ae_txn_rec.xfer_organization_id)
4030: AND HOI.org_information_context = 'Accounting Information'

Line 4035: FROM hr_organization_information HOI2

4031: AND MIP.ship_organization_id = to_number(HOI.org_information3)
4032: AND ROWNUM < 2) > 0
4033:
4034: AND (select count(1)
4035: FROM hr_organization_information HOI2
4036: WHERE HOI2.organization_id = decode(i_ae_txn_rec.txn_action_id, 21,
4037: i_ae_txn_rec.xfer_organization_id,
4038: i_ae_txn_rec.organization_id)
4039: AND HOI2.org_information_context = 'Accounting Information'

Line 9080: FROM hr_organization_information

9076:
9077: l_stmt_num := 30;
9078: SELECT to_number(org_information3)
9079: INTO l_from_ou
9080: FROM hr_organization_information
9081: WHERE org_information_context = 'Accounting Information'
9082: AND organization_id = l_from_org;
9083:
9084: l_stmt_num := 35;

Line 9087: FROM hr_organization_information

9083:
9084: l_stmt_num := 35;
9085: SELECT to_number(org_information3)
9086: INTO l_to_ou
9087: FROM hr_organization_information
9088: WHERE org_information_context = 'Accounting Information'
9089: AND organization_id = l_to_org;
9090:
9091: if (g_debug_flag = 'Y') then