1502:
1503: /*Added by sowsubra*/
1504: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
1505: SELECT status_id
1506: FROM mtl_secondary_inventories
1507: WHERE secondary_inventory_name = p_subinv_code
1508: AND organization_id = p_org_id;
1509:
1510: /*Added by sowsubra*/
2873:
2874: /*Added by sowsubra*/
2875: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
2876: SELECT status_id
2877: FROM mtl_secondary_inventories
2878: WHERE secondary_inventory_name = p_subinv_code
2879: AND organization_id = p_org_id;
2880:
2881: /*Added by sowsubra*/