APPS.CSTPAPBR dependencies on HR_ORGANIZATION_INFORMATION

Line 2306: from hr_organization_information HOI

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,
2308: 21, i_ae_txn_rec.organization_id,
2309: i_ae_txn_rec.xfer_organization_id)
2310: AND HOI.org_information_context = 'Accounting Information'

Line 2314: from hr_organization_information HOI2

2310: AND HOI.org_information_context = 'Accounting Information'
2311: AND MIP.ship_organization_id = to_number(HOI.org_information3)
2312: AND ROWNUM < 2) >0
2313: AND ( select count(1)
2314: from hr_organization_information HOI2
2315: where HOI2.organization_id = decode(i_ae_txn_rec.txn_action_id,
2316: 21, i_ae_txn_rec.xfer_organization_id,
2317: i_ae_txn_rec.organization_id)
2318: AND HOI2.org_information_context = 'Accounting Information'

Line 4308: FROM hr_organization_information HOI

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,
4310: i_ae_txn_rec.organization_id,
4311: i_ae_txn_rec.xfer_organization_id)
4312: AND HOI.org_information_context = 'Accounting Information'

Line 4317: FROM hr_organization_information HOI2

4313: AND MIP.ship_organization_id = to_number(HOI.org_information3)
4314: AND ROWNUM < 2) > 0
4315:
4316: AND (select count(1)
4317: FROM hr_organization_information HOI2
4318: WHERE HOI2.organization_id = decode(i_ae_txn_rec.txn_action_id, 21,
4319: i_ae_txn_rec.xfer_organization_id,
4320: i_ae_txn_rec.organization_id)
4321: AND HOI2.org_information_context = 'Accounting Information'

Line 9521: FROM hr_organization_information

9517:
9518: l_stmt_num := 30;
9519: SELECT to_number(org_information3)
9520: INTO l_from_ou
9521: FROM hr_organization_information
9522: WHERE org_information_context = 'Accounting Information'
9523: AND organization_id = l_from_org;
9524:
9525: l_stmt_num := 35;

Line 9528: FROM hr_organization_information

9524:
9525: l_stmt_num := 35;
9526: SELECT to_number(org_information3)
9527: INTO l_to_ou
9528: FROM hr_organization_information
9529: WHERE org_information_context = 'Accounting Information'
9530: AND organization_id = l_to_org;
9531:
9532: if (g_debug_flag = 'Y') then