1020: where employee_id = v_emp_id;
1021:
1022: CURSOR item_expense_account is
1023: select msi.expense_account
1024: from mtl_system_items msi,
1025: icx_shopping_carts isc,
1026: icx_shopping_cart_lines iscl
1027: where msi.inventory_item_id(+) = iscl.item_id
1028: AND nvl(msi.ORGANIZATION_ID,
1177: where employee_id = v_emp_id;
1178:
1179: CURSOR item_expense_account is
1180: select msi.expense_account
1181: from mtl_system_items msi,
1182: icx_shopping_carts isc,
1183: icx_shopping_cart_lines iscl
1184: where msi.inventory_item_id(+) = iscl.item_id
1185: AND nvl(msi.ORGANIZATION_ID,