APPS.CSTPPINV dependencies on HR_ORGANIZATION_INFORMATION

Line 828: FROM hr_organization_information HOI

824: FROM mtl_intercompany_parameters MIP
825: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
826: AND MIP.flow_type = 1
827: AND MIP.ship_organization_id = (SELECT to_number(HOI.org_information3)
828: FROM hr_organization_information HOI
829: WHERE HOI.organization_id = l_from_org
830: AND HOI.org_information_context = 'Accounting Information')
831: AND MIP.sell_organization_id = (SELECT to_number(HOI2.org_information3)
832: FROM hr_organization_information HOI2

Line 832: FROM hr_organization_information HOI2

828: FROM hr_organization_information HOI
829: WHERE HOI.organization_id = l_from_org
830: AND HOI.org_information_context = 'Accounting Information')
831: AND MIP.sell_organization_id = (SELECT to_number(HOI2.org_information3)
832: FROM hr_organization_information HOI2
833: WHERE HOI2.organization_id = l_to_org
834: AND HOI2.org_information_context = 'Accounting Information');
835: EXCEPTION
836: WHEN NO_DATA_FOUND THEN

Line 2229: FROM hr_organization_information

2225: l_stmt_num := 10;
2226:
2227: SELECT org_information1
2228: INTO l_snd_sob_id
2229: FROM hr_organization_information
2230: WHERE organization_id = i_from_org
2231: and org_information_context = 'Accounting Information';
2232:
2233: l_stmt_num := 20;

Line 2244: FROM hr_organization_information

2240: l_stmt_num := 30;
2241:
2242: SELECT org_information1
2243: INTO l_rcv_sob_id
2244: FROM hr_organization_information
2245: WHERE organization_id = i_to_org
2246: and org_information_context = 'Accounting Information';
2247:
2248: l_stmt_num := 40;