64: END IF;
65: -- LE Uptake
66: SELECT hoi.org_information1
67: INTO l_ledger_id
68: FROM hr_organization_information hoi,
69: wsh_new_deliveries wnd
70: WHERE wnd.delivery_id = p_entity_id
71: AND hoi.organization_id = wnd.organization_id
72: AND hoi.org_information_context = 'Accounting Information';
265: --l_ledger_id := 1;
266:
267: SELECT hoi.org_information1
268: INTO l_ledger_id
269: FROM hr_organization_information hoi,
270: wsh_new_deliveries wnd
271: WHERE wnd.delivery_id = p_entity_id
272: AND hoi.organization_id = wnd.organization_id
273: AND hoi.org_information_context = 'Accounting Information';