APPS.CSTPPINV dependencies on HR_ORGANIZATION_INFORMATION

Line 786: FROM hr_organization_information HOI

782: FROM mtl_intercompany_parameters MIP
783: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
784: AND MIP.flow_type = 1
785: AND MIP.ship_organization_id = (SELECT to_number(HOI.org_information3)
786: FROM hr_organization_information HOI
787: WHERE HOI.organization_id = l_from_org
788: AND HOI.org_information_context = 'Accounting Information')
789: AND MIP.sell_organization_id = (SELECT to_number(HOI2.org_information3)
790: FROM hr_organization_information HOI2

Line 790: FROM hr_organization_information HOI2

786: FROM hr_organization_information HOI
787: WHERE HOI.organization_id = l_from_org
788: AND HOI.org_information_context = 'Accounting Information')
789: AND MIP.sell_organization_id = (SELECT to_number(HOI2.org_information3)
790: FROM hr_organization_information HOI2
791: WHERE HOI2.organization_id = l_to_org
792: AND HOI2.org_information_context = 'Accounting Information');
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN

Line 2187: FROM hr_organization_information

2183: l_stmt_num := 10;
2184:
2185: SELECT org_information1
2186: INTO l_snd_sob_id
2187: FROM hr_organization_information
2188: WHERE organization_id = i_from_org
2189: and org_information_context = 'Accounting Information';
2190:
2191: l_stmt_num := 20;

Line 2202: FROM hr_organization_information

2198: l_stmt_num := 30;
2199:
2200: SELECT org_information1
2201: INTO l_rcv_sob_id
2202: FROM hr_organization_information
2203: WHERE organization_id = i_to_org
2204: and org_information_context = 'Accounting Information';
2205:
2206: l_stmt_num := 40;