APPS.CSM_MULTI_MOBQRY_PKG dependencies on MTL_PARAMETERS

Line 1402: FROM HR_ALL_ORGANIZATION_UNITS_TL tl,mtl_parameters p

1398:
1399:
1400: /*CURSOR C_GET_ORG(p_ORG_ID NUMBER) IS
1401: SELECT p.master_organization_id,tl.NAME
1402: FROM HR_ALL_ORGANIZATION_UNITS_TL tl,mtl_parameters p
1403: WHERE LANGUAGE = asg_base.get_language(p_user_name)
1404: AND tl.ORGANIZATION_ID = p.master_organization_id
1405: AND p.ORGANIZATION_ID =p_org_id;*/
1406:

Line 1415: SELECT organization_code from mtl_parameters

1411: AND tl.ORGANIZATION_ID = p_org_id;
1412:
1413:
1414: CURSOR C_GET_ORG_CODE(p_ORG_ID NUMBER) IS
1415: SELECT organization_code from mtl_parameters
1416: WHERE ORGANIZATION_ID =p_org_id;
1417:
1418: CURSOR c_get_ohq(b_req_item_id NUMBER) IS
1419: SELECT acc.organization_id, acc.subinventory_code,acc.REQUIRED_ITEM_ID,acc.REQUIRED_ITEM_REV,acc.REQUIRED_QUANTITY,