APPS.WSH_BOLS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 130: FROM hr_organization_information hoi,

126: END IF;
127: --
128:
129: SELECT to_number(HOI.ORG_INFORMATION1) INTO l_ledger_id -- LE Uptake
130: FROM hr_organization_information hoi,
131: wsh_new_deliveries wnd
132: WHERE HOI.ORGANIZATION_ID = wnd.organization_id
133: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information'
134: AND wnd.delivery_id = p_delivery_id;

Line 382: FROM hr_organization_information hoi,

378:
379: -- l_set_of_books_id := 1;
380:
381: SELECT to_number(HOI.ORG_INFORMATION1) INTO l_ledger_id -- LE Uptake
382: FROM hr_organization_information hoi,
383: wsh_new_deliveries wnd
384: WHERE HOI.ORGANIZATION_ID = wnd.organization_id
385: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information'
386: AND wnd.delivery_id = x_delivery_id;