DBA Data[Home] [Help]

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,

432: l_count NUMBER;
433: l_return_status VARCHAR2(80);
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag

Line 437: c_item_org_id mtl_system_items_b.organization_id%TYPE,

433: l_return_status VARCHAR2(80);
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si

Line 438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS

434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si
442: WHERE si.inventory_item_id = c_inventory_item_id