APPS.WSH_PACKING_SLIPS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 68: FROM hr_organization_information hoi,

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';

Line 269: FROM hr_organization_information hoi,

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';