APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on MTL_PARAMETERS

Line 44: FROM mtl_parameters

40: IF p_organization_id IS NOT NULL AND p_organization_id <> FND_API.G_MISS_NUM THEN
41: -- organization_id takes precedence
42: BEGIN
43: SELECT organization_code INTO x_organization_code
44: FROM mtl_parameters
45: WHERE organization_id = p_organization_id;
46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
48: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');

Line 58: FROM mtl_parameters

54: ELSIF p_organization_code IS NOT NULL AND p_organization_code <> FND_API.G_MISS_CHAR THEN
55:
56: BEGIN
57: SELECT organization_id INTO x_organization_id
58: FROM mtl_parameters
59: WHERE organization_code = p_organization_code;
60: EXCEPTION
61: WHEN NO_DATA_FOUND THEN
62: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_CODE');

Line 491: FROM mtl_parameters

487: IF p_organization_id IS NULL THEN
488: RETURN NULL;
489: ELSE
490: SELECT expense_account INTO l_expense_account_id
491: FROM mtl_parameters
492: WHERE organization_id = p_organization_id;
493:
494: RETURN l_expense_account_id;
495: END IF;

Line 660: FROM mtl_parameters

656: IF p_organization_id IS NULL THEN
657: RETURN NULL;
658: ELSE
659: SELECT master_organization_id INTO l_master_org_id
660: FROM mtl_parameters
661: WHERE organization_id = p_organization_id;
662:
663: RETURN l_master_org_id;
664: END IF;

Line 1241: FROM mtl_system_items msi, mtl_parameters mp

1237: RETURN NULL;
1238: ELSE
1239: SELECT msi.serial_number_control_code
1240: INTO l_serial_number_control_code
1241: FROM mtl_system_items msi, mtl_parameters mp
1242: WHERE mp.maint_organization_id = p_organization_id
1243: AND mp.organization_id = msi.organization_id
1244: AND msi.inventory_item_id = p_maint_id
1245: AND ROWNUM = 1;