1860: CURSOR l_shipping_le IS
1861: SELECT
1862: TO_NUMBER(org_information2)
1863: FROM
1864: hr_organization_information
1865: WHERE org_information_context = 'Accounting Information'
1866: AND organization_id = p_warehouse_id;
1867:
1868: BEGIN
2205: CURSOR c_org_id
2206: IS
2207: SELECT
2208: organization_id
2209: FROM hr_organization_information
2210: WHERE org_information_context = 'Accounting Information'
2211: AND to_number(org_information2) = p_le_id
2212: AND rownum = 1;
2213: BEGIN