APPS.EAM_ASSET_LOG_PVT dependencies on MTL_PARAMETERS

Line 86: FROM mtl_parameters mp, csi_item_instances cii

82: IF p_event_type='EAM_SYSTEM_EVENTS' THEN
83: BEGIN
84: SELECT mp.maint_organization_id, cii.operational_log_flag
85: INTO l_organization_id, l_status
86: FROM mtl_parameters mp, csi_item_instances cii
87: WHERE mp.organization_id = cii.last_vld_organization_id
88: AND cii.instance_id = p_instance_id;
89:
90: IF (l_status = 'N' or l_status is NULL) THEN

Line 570: from mtl_parameters

566: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
567:
568: begin
569: select nvl(maint_organization_id, p_organization_id) into l_organization_id
570: from mtl_parameters
571: where organization_id = p_organization_id;
572: exception
573: WHEN NO_DATA_FOUND THEN
574:

Line 702: FROM mtl_parameters mp, csi_item_instances cii

698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: BEGIN
701: SELECT mp.maint_organization_id INTO l_organization_id
702: FROM mtl_parameters mp, csi_item_instances cii
703: WHERE mp.organization_id = cii.last_vld_organization_id
704: AND cii.instance_id = p_instance_id;
705:
706: EXCEPTION

Line 1294: FROM mtl_parameters

1290: l_instance_id := l_cmetid.instance_id;
1291: l_instance_number := l_cmetid.instance_number;
1292:
1293: SELECT maint_organization_id INTO l_organization_id
1294: FROM mtl_parameters
1295: WHERE organization_id = l_cmetid.org_id;
1296:
1297: EAM_ASSET_LOG_PVT.validate_event(
1298: p_event_date => p_event_date,